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 Dashboard. In this recipe and the next recipe, we use the MDX query window in SSMS.
It is also worth mentioning that although DMV query syntax is based on a SQL SELECT statement, it does not support the full syntax of a SELECT statement...
