OLAP with asp.net

[Shailesh]

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

[Alvin Bruney [MVP - ASP.NET]]

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" <Sh******@discussions.microsoft.com> wrote in message
news:5A**********************************@microsof t.com...

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

[Shailesh]

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 [MVP - ASP.NET]" wrote:

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" <Sh******@discussions.microsoft.com> wrote in message
news:5A**********************************@microsof t.com...

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