sysobjects for ssas

• DVaughan 11378

  SSC Enthusiast

  Points: 178

  More actions

  August 30, 2011 at 7:57 am

  #247350

  In SQL Server, I can query sysobjects, syscolumns, syscomments etc to get information about the objects in the database. Is there a similar MDX query I can run to gain information on the objects in a cube?

  Many thanks.

• Kees Beimans

  SSC Eights!

  Points: 978

  More actions

  August 30, 2011 at 8:19 am

  #1375030

  Hi,

  You can obtain information of the Analysis Services objects with DMV (Dynamic Management View) statements.

  See also: http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

  Regards Kees

• DVaughan 11378

  SSC Enthusiast

  Points: 178

  More actions

  August 30, 2011 at 11:22 am

  #1375153

  Thank you for the treasure trove of MDX. Wow! I've got some reading to do...

  Kind regards,

  David