DMV Queries: To Get All Attributes in a cube

Use below Dynamic Management View (DMV) queries to get all the dimension and attributes of your cube

SELECT

       [CATALOG_NAME] as [Database],

       CUBE_NAME AS [Cube],

       [DIMENSION_UNIQUE_NAME] AS [Dimension],

       HIERARCHY_DISPLAY_FOLDER AS [FOLDER],

       HIERARCHY_CAPTION AS [DIMENSION ATTRIBUTE],

       HIERARCHY_IS_VISIBLE AS [VISIBLE]

FROM

       $system.MDSchema_hierarchies

WHERE 

       CUBE_NAME  ='My Cube Name' AND 

       HIERARCHY_ORIGIN=2

ORDER BY

       [DIMENSION_UNIQUE_NAME]

 

Note: Replace 'My Cube Name' with your cube name