Analysis Services 2008 $SYSTEM.MDSCHEMA_% DMVs
In Analysis Services 2008 there are 13 MDSCHEMA Dynamic Management Views (DMVs):
- $SYSTEM.MDSCHEMA_CUBES
- $SYSTEM.MDSCHEMA_DIMENSIONS
- $SYSTEM.MDSCHEMA_FUNCTIONS
- $SYSTEM.MDSCHEMA_HIERARCHIES
- $SYSTEM.MDSCHEMA_INPUT_DATASOURCES
- $SYSTEM.MDSCHEMA_KPIS
- $SYSTEM.MDSCHEMA_LEVELS
- $SYSTEM.MDSCHEMA_MEASUREGROUP_DIMENSIONS
- $SYSTEM.MDSCHEMA_MEASUREGROUPS
- $SYSTEM.MDSCHEMA_MEASURES
- $SYSTEM.MDSCHEMA_MEMBERS
- $SYSTEM.MDSCHEMA_PROPERTIES
- $SYSTEM.MDSCHEMA_SETS
These DMVs describe cubes, dimensions, functions, measures, etc in Analysis Services database.
Here is a diagram that I got after exporting structure of above DMVs into SQL Server database:
(Click on the image to enlarge)