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

 

[Chris Harrington]

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

 

[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.aspx?scid=kb;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

 

[Thao Moua [ms]]

Use this code to bind chart to an OLAP server

webchart.ConnectionString = "Provider=MSOLAP.2;Persist
Security Info=False;User ID=guest;Password=guest;Data
Source=SERVER_NAME;Connect Timeout=60;Initial
Catalog=FoodMart;Client Cache Size=25;Auto Synch
Period=10000;"
webchart.DataMember = "Sales"

Thao Moua
OWC Webchart Support

 

[mrwoopey]

Thao,

Thank you for your reply. The code that you posted could you please
put it within some context (I couldn't get it to work). Basically, how
would I use your snippet of code with the code that displays a OLAP
data cube chart? Would your snippet of code make the OLAP data cube
chart dynamic?

Thanks,

Phin

 

[Thao Moua [ms]]

The code provided will connect webchart to an OLAP
server. Just insert your Data Source, Catalog, user name
& ID, and the DataMember values.

Thao Moua
OWC Webchart Support

-----Original Message-----
Thao,

Thank you for your reply. The code that you posted could you please
put it within some context (I couldn't get it to work). Basically, how
would I use your snippet of code with the code that displays a OLAP
data cube chart? Would your snippet of code make the OLAP data cube
chart dynamic?

Thanks,

Phin

"Thao Moua [ms]" <[email protected]> wrote

in message [email protected]>...