XML/A client

XML/A client

Post by Suma » Sun, 21 Nov 2004 04:21:43


Is there any way to write SQL Analysis Services client
without creating MDX queries? I mean a programmatic way
to get the dimensions members etc without having to
construct MDX.

Thanks,

--Suman
 
 
 

XML/A client

Post by Akshai Mir » Sun, 21 Nov 2004 05:34:44

You can use schema rowsets in ADOMD.NET to get the members of dimensions,
but to get cell values you need to use MDX.

Thanks,
Akshai

 
 
 

XML/A client

Post by aaron_kemp » Fri, 03 Dec 2004 07:08:19

If you're looking for an interface to MDX; does't the PivotTable control
write MDX for you?

-aaron




newsgroup
 
 
 

XML/A client

Post by aaron_kemp » Sun, 12 Dec 2004 06:55:40

sorry i guess that it doesn't.. right?

I sure wish that it did

-aaron






dimensions,
rights
 
 
 

XML/A client

Post by Rick Razza » Mon, 31 Jan 2005 16:07:19

Actually, you can log the MDX used by PT services on the client side. Find
the .oqy file that is used for the cube (normally these are in c:\documents
and settings\sernameapplication data\microsoft\queries). Then add Log
File=ilespecto the line that starts with "Connection" , where ilespec is a file name with path and an extension of .log or .txt
(c:\temp\olaplog.txt, for instance).

This will write any MDX queries used by pivot tables using that .oqy file to
the log file.

HTH