O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by 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 (DMV) to fast-document a cube

Dynamic Management Views are Analysis Services schema rowsets (XML metadata) exposed as tables which can be queried like any other relational table, using SQL queries. There are restrictions in what we can do, what types of queries and data manipulations are available to us when we use DMVs. In general, the idea is to expose several collections of information about SSAS and to be able to browse those using SQL queries.

The first collection of DMVs is the DBSCHEMA collection which consists of 4 DMVs. Its purpose is to provide various metadata about tables and other relational objects that SSAS databases are built from. For example, the list of columns in dimension tables in DSV. ...

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