dbTalk Databases Forums  

Convert MDX Result into appropriate xml

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Convert MDX Result into appropriate xml in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prasad
 
Posts: n/a

Default Convert MDX Result into appropriate xml - 04-18-2005 , 03:24 PM






Hi,

I want to write a C# .Net application to convert the results of an MDX query
to XML. My query can have a maximum of 3 row dimensions and 3 column
dimensions. I want to use ADOMD.Net so that i do not have to deal with
Interop.
Can you please provide sample code to do this.

Also, what is the eqvivalent of DSO in .Net? Is there something like DSO.Net
like DOMD.Net?

Thanks,
Sam

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Convert MDX Result into appropriate xml - 04-18-2005 , 07:04 PM






Look at the ADOMD.NET documentation. I believe that there is an option to
get the cellset rendered in XML.

BTW: No, there is no managed interface for DSO. You have to use COM interop.
If you are looking for an example, see the DSO/XML source code:
http://www.microsoft.com/downloads/d...DisplayLang=en
It is written in VB.NET.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,

I want to write a C# .Net application to convert the results of an MDX
query
to XML. My query can have a maximum of 3 row dimensions and 3 column
dimensions. I want to use ADOMD.Net so that i do not have to deal with
Interop.
Can you please provide sample code to do this.

Also, what is the eqvivalent of DSO in .Net? Is there something like
DSO.Net
like DOMD.Net?

Thanks,
Sam



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.