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] 
FROM $SYSTEM.MDSCHEMA_PROPERTIES 
WHERE Cube_Name = 'HERE_PUT_CUBE_NAME' And [Property_Type] = 1



Author info
Author: Stanislav DubenWebsite: http://www.duben.org
About me
I am experienced database engineer with more than 12 years developing and optimization experience. I worked on many high level projects based on SQL servers. I am also photograper and owner of many internet projects.

Add comment

Security code
Refresh