O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required