MDX Queries within .NET SSAS stored procedures (using ADOMD.NET Server library)

It seems like it is not possible to write MDX queries within Analysis Services Stored procedures utilizing the Microsoft.AnalysisServices.AdomdServer library. Is this correct ?

I am able to execute DMX queries but not sure about MDX

Can anyone elaborate on this ?

thanks

anil

Not sure with it, but you can check in:

http://technet.microsoft.com/en-us/library/ms175314.aspx

http://www.codeplex.com/ASStoredProcedures/Project/ProjectRss.aspx

|||

That is basically correct. Stored Procedures in SSAS can return things like values, members, sets, tuples, but they are not built to execute queries. At least in their current form, "Stored Procedures" is not really a good name, they are more like .Net user defined functions.

Technically it would be possible to use the CALL syntax to open up a second ADOMD connection and execute an MDX query and return the result as a rowset, but that would require that the stored proc have unrestricted permissions and it is not really a recommended practice.

|||

Darren

Thanks, i agree that this should really be called a .NET user defined function

I was hoping to obtain a AdomdDataReader for an MDX query and process the results in the .NET user defined function, so getting a rowset will not work for me. I will have to resort to processing on the client, using the client libraries

anil