MDX Query for the cube information?

Looking for some suggestions from SSAS experts.

Actually I had created few cubes in the server. I would like to retrieve the information about the available cubes and its dimensions & measures programmatically. I would like to use this metadata information in one of the .Net applications. Any idea how to do this?

Is it possible to write an MDX query which gives the names of the available cubes & its dimensions, measures in a server? Or is there any other approach for this?

Would appreciate any help in this regard.

Regards
Jacob

Hi,

ADOMD.NET should give you what you need take a look at http://msdn2.microsoft.com/en-us/library/ms123485.aspx. If you want to mange the objects then use Analysis Management Objects (AMO) http://msdn2.microsoft.com/en-us/library/ms345089.aspx.

Thanks

Giles

|||Thanks a lot !!!

Regards,
Jacob