Report Portal

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:

MDSCHEMA DMVs

(Click on the image to enlarge)

 

Tags: faq, dmv

 

2007-2015 VidasSoft Systems Inc.