Analysis Services 2008 $SYSTEM.DMSCHEMA_% DMVs

Written by Vidas Matelis. Posted in SSAS 2008 DMVs

In Analysis Services 2008 there are 10 DMSCHEMA Dynamic Management Views (DMVs).

$SYSTEM.DMSCHEMA_MINING_COLUMNS
$SYSTEM.DMSCHEMA_MINING_FUNCTIONS
$SYSTEM.DMSCHEMA_MINING_MODEL_CONTENT
$SYSTEM.DMSCHEMA_MINING_MODEL_CONTENT_PMML
$SYSTEM.DMSCHEMA_MINING_MODEL_XML
$SYSTEM.DMSCHEMA_MINING_MODELS
$SYSTEM.DMSCHEMA_MINING_SERVICE_PARAMETERS
$SYSTEM.DMSCHEMA_MINING_SERVICES
$SYSTEM.DMSCHEMA_MINING_STRUCTURE_COLUMNS
$SYSTEM.DMSCHEMA_MINING_STRUCTURES

These DMVs describe data mining models in the Analysis Services database.

Here is a diagram that I got after exporting structure of above DMVs into SQL Server database:

Tags: faq, dmv