Help: Displaying Web OLAP cube in a web chart

mrwoopey

Hi,

I have a web based OLAP cube (based on the SQL 2000 resource kit
version) and I need to know how to display it in a chart (web based).
I know that there are 3rd party tools but I need a cheaper way to do
this.

Please post any code or links. You help is greatly appreciated!

Thanks,

Phin

Nov 17 '05 #1

Subscribe Reply

3393

Chris Harrington

Office Web Controls is probably a good option. Also check out the new
ChartFX OLAP charts.

"mrwoopey" <mr******@yahoo .com> wrote in message
news:e4******** *************** ***@posting.goo gle.com...

Hi,

I have a web based OLAP cube (based on the SQL 2000 resource kit
version) and I need to know how to display it in a chart (web based).
I know that there are 3rd party tools but I need a cheaper way to do
this.

Please post any code or links. You help is greatly appreciated!

Thanks,

Phin

Nov 17 '05 #2

mrwoopey

Chris,

Thanks for the reply. Yeah, I was looking into Chart FX, it looks
really good. I was hoping to find a cheaper way to do this.

I was able to find an article that describes converting OLAP cubes to
a chart, but you can't just pass it the MDX (which would be dynamic),
you need to hardcode a recordset to display the chart (via office
components):

http://support.microsoft.com/default...b;en-us;279254

If you have a dynamic solution (like passing the MDX or building the
recordset on the fly to build the chart), that would be much
appreciated.

Either way, thanks!

Phin

"Chris Harrington" <ch***@activein terface.com> wrote in message news:<#q******* *******@TK2MSFT NGP11.phx.gbl>. ..

Office Web Controls is probably a good option. Also check out the new
ChartFX OLAP charts.

"mrwoopey" <mr******@yahoo .com> wrote in message
news:e4******** *************** ***@posting.goo gle.com...
Hi,

I have a web based OLAP cube (based on the SQL 2000 resource kit
version) and I need to know how to display it in a chart (web based).
I know that there are 3rd party tools but I need a cheaper way to do
this.

Please post any code or links. You help is greatly appreciated!

Thanks,

Phin

Nov 17 '05 #3

Similar topics

3351

Oracle 9IR2 OLAP and BI Beans - How to get it working

by: DD | last post by:

Hi Guys! Just would like to share with you my experiense in this matter. I was trying to evaluate how suitable Oracle OLAP for our applications. As probably you did, I have downloaded from OTN website OraJDeveloper and BI Beans, installed them and opened Cube Viewer ... no luck! Just did not work. After very long conversation(s) with...

Oracle Database

3714

OLAP Cubes and Programming

by: Devin McMahon | last post by:

I cannot seem to find a group where this question would fit so I am posting it here. I have what I believe is a unique situation. I am using SQL Server Analysis Server to build a cube of "snapshot" month-end type of data. This data is from an instance of Microsoft Navision and I have successfully used SQL-DMO and DTSPackage Library objects...

Microsoft SQL Server

3102

HELP: OLAP data cube in web browser loads slow or errors!

by: mrwoopey | last post by:

Hi, I am using the OLAP data cube in a web browser (using the code from the SQL 2000 toolkit). The OLAP services is on database server and the web interface is on the web server. If we do simple queries on the cube, it works fine. When we do complex queries the cube in the web browser loads very slow or errors. Also, I noticed that when it...

Microsoft SQL Server

6509

Cristal Reports for OLAP CUBE

by: Pradeep | last post by:

I have created a crystal report connecting an OLAP cube .But once i try to view a report it took around 15 minutes and finaly gave an error like "cannot retrieve data from cube".I want to know why it is and how can i create a crystal report for OLAP CUB.

Microsoft SQL Server

1635

How to connect to a MSSQL 2000 OLAP Server

by: Moco | last post by:

Well I installed my first OLAP Server ever just yesterday, allright. I built my first cube with a data source from a MSSQL Server 2000 on the same machine, allright. I browsed the cube with Analysis Manager, allright. Then , my real goal: I want to connect to OLAP Server in much the same way as I use to do with SQL Server, that is from my...

Microsoft SQL Server

1913

English version of the vs.net OLAP control - Visual Studio .NET Web Control for Business Intelligence

by: mrwoopey | last post by:

Hi, Instead of using the Japanese version of the OLAP control for vs.net there is now an English version: Visual Studio .NET Web Control for Business Intelligence - http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en It works fine with the Foodmart 2000 example (don't they all)...

.NET Framework

2118

DTS running in C# does not work when processing olap cube

by: Joel Leong | last post by:

I use C# to invoke DTS. The DTS run successfully if no process cube function in it. But after i add process cube function, the ASP.NET page hang. I even impersonate ASP.NET to an account with OLAP Administrator and System administrator. it jus hang there. So what is the problem I'm having? It is working fine when no processing OLAP command...

ASP.NET

1266

small OLAP cube vs large OLAP cube

by: jai83 | last post by:

hi,what are the features that decide that a particular OLAP cube is small or large?? Is it the number of tuples or the number of dimensions that are persent in the cube? thanks a lot !!!

DB2 Database

4804

Olap cube as a Data Source

by: =?Utf-8?B?TWFyaw==?= | last post by:

Hi - Is is possible to connect to a data source that is an OLAP Cube? If so what are the steps that are needed to "Add New Data Source"? Thank you, Mark

C# / C Sharp

8125

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7676

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6284

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5513

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5219

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3653

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2114

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1221

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General