OLAP with asp.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I want to convert ADOMD cellset to XML format so that it can viewed in OWC
10 chartspace.I am using SQL server OLAP services.What should i do?

My problem is as follows:
I have used the custom control whose link is given below.This drag drop
control displays the data in grid.Now i want to display this data in OWC 10
chartspace.Pls guide sir.

<http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm>

Thanks in advance.
Shailesh
 
You can simply connect the chartspace to the olap datasource if you can
configure the olap source to output XML, otherwise, you will need to build a
middle layer to convert the data to xml for you. OWC accepts other formats
as well.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc
 
Hi Alvin,

Thanks for your reply.
My Problem is that I need to convert CellSet data in XML format. I dont know
how to convert it. My OWC take accepts data in XML format, I dont know if OWC
takes any other format also. Can u specify how to set format for OWC and also
how to convert Cellset data in XML format.

Thanking you.
Shailesh.

Alvin Bruney said:
You can simply connect the chartspace to the olap datasource if you can
configure the olap source to output XML, otherwise, you will need to build a
middle layer to convert the data to xml for you. OWC accepts other formats
as well.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc
Shailesh said:
Hi Everyone,

I want to convert ADOMD cellset to XML format so that it can viewed in OWC
10 chartspace.I am using SQL server OLAP services.What should i do?

My problem is as follows:
I have used the custom control whose link is given below.This drag drop
control displays the data in grid.Now i want to display this data in OWC
10
chartspace.Pls guide sir.

<http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm>

Thanks in advance.
Shailesh
Click to expand...
Click to expand...
 
Back
Top