List Dimension Names of a Cube and their attributes

• amendieta

  Old Hand

  Points: 307

  More actions

  February 9, 2012 at 3:19 pm

  #147011

  Looking to list Dimension Names of a Cube and their attributes. Thanks for any help.

  Something like this gives me the values of an attribute, but I'm looking for the actual attribute and dimension names.

  WITH MEMBER nameVal

  AS [CUSTOMER].[PRIVATE PRACTICE].currentMember.Name

  SELECT {nameVal} ON COLUMNS,

  ([CUSTOMER].[PRIVATE PRACTICE].Children) ON ROWS

  FROM [Sales Cube]

• richykong

  SSCommitted

  Points: 1502

  More actions

  February 13, 2012 at 9:16 am

  #1446320

  I've used the following queries and SSRS reports to extract metadata around SSAS objects.

  http://www.purplefrogsystems.com/blog/2011/05/video-automating-ssas-olap-cube-documentation/

• amendieta

  Old Hand

  Points: 307

  More actions

  February 13, 2012 at 10:07 am

  #1446345

  This is an incredible Blog site - very informative and helpful. Thank you so much.