Skip to main content
Analysis Services 2008 $SYSTEM.MDSCHEMA_% DMVs
Entry Date: Rate:
Site:
Keywords:
RSS Description:

In Analysis Services 2008 there are 13 MDSCHEMA Dynamic Management Views (DMVs).

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.

Comments:

One of the tasks that we developers hate to do is... generation documentation :-)

SSAS provides you with DMV, you can create a linked server and via openqueries can extract the info that you need (you can use that queries on SSRS to get a nice layout)

In this post you will get a tables diagram that will tell you which info can you extract from that DMV.