Hot to get list of OLAP dimensions with attributes used in CUBE

SQL icon baseIn case you need create list off all dimensions used in cube on Microsoft SQL server, with list of all dimension attributes. There is easy and simple way how to do it with query.

First in Microsoft SQL Server Management Studio connect to Analytics server, find database you need to use and with right mouse button open new DMX query.

Then in this this query replac "HERE_PUT_CUBE_NAME" by your cube name and run it. In case you need there are a lot more information in table $SYSTEM.MDSCHEMA_PROPERTIES

SELECT distinct [Dimension_Unique_Name],[Property_Name], [Property_Caption] 
WHERE Cube_Name = 'HERE_PUT_CUBE_NAME' And [Property_Type] = 1

Add comment

Security code