Using SSAS Dynamic Management Views (DMVs) to fast-document a cube

Dynamic Management Views (DMV) are Analysis Services schema rowsets (XML/A metadata) exposed as tables, which can be queried with SELECT statements.

DMVs expose information about local Analysis Services server metadata and server operations. For most DMV queries, you use a SELECT statement and the $System schema with an XML/A schema rowset:

SELECT * FROM $System.<schemaRowset> 

The query engine for DMVs is the Data Mining parser. The DMV query syntax is based on the SELECT (DMX) statement. To execute DMV queries, you can use any client application that supports MDX or DMX (Data Mining) queries, including SQL Server Management Studio, a Reporting Services Report, or a Performance Point ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.