Dynamic Management Views (DMV) are Analysis Services schema rowsets (XML/A metadata) exposed as tables, which can be queried with
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 ...