List all cube,dimesnrions,measures in ssas

• gugan_ta

  SSCommitted

  Points: 1649

  More actions

  September 20, 2009 at 12:57 pm

  #211016

  D/A

  How to list all cubes, dimensions, partitions in SSAS.

  Pls help is there any query to retrieve the same.

  Thanks...Gugan

• mRainey

  Right there with Babe

  Points: 796

  More actions

  September 21, 2009 at 11:41 am

  #1056405

  Hi Gugan,

  It looks like you can use an XMLA Discover query to look up this information. You can find an example here http://technet.microsoft.com/en-us/library/ms186653.aspx.

  Another option would be to use the AMO (Analysis Management Objects) API in a .NET application.

  ~Thanks to the user at StackOverflow for the answer.

  Hope this helps!

  Michael R.

• Hendra Eka Putra

  SSCrazy

  Points: 2015

  More actions

  September 24, 2009 at 8:44 am

  #1058069

  I'm going to choose AMO. See the sample code in http://www.codeplex.com