SSAS: How to find a Calculated Measure and Calculated Dimension within a particular cube.
INTRODUCTION:
This article will allow you to know how to find Calculated Measure and Calculated Dimension within a particular cube in SSAS.
OVERVIEW:
To list the calculated measures within a particular cube, we have to open the BIDS project and lookup how many calculated measures were made and their names which seems little odd. So, after some research and trying out DMV queries we finally got a simple way.
IN BRIEF:
DMV:
Dynamic Management Views was introduced in Analysis Services 2008 and is used to track the server resources used. It can be queried with like SQL-like syntax. We can run DMV query in SQL Server Management Studio in an MDX Query.
For Calculated Measure and Calculated Dimension Member (or other entire details of Cube Catalog from SSAS)
SELECT * FROM $system.MDSCHEMA_MEMBERS
WHERE [MEMBER_TYPE] = 4
SUMMARY:
From this article, now you are able to find easily every Calculated Measure and Calculated Dimension within a particular cube in SSAS
REFERENCES:
Reference some other DMV queries from the link: http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/