Analysis Services 2008 $SYSTEM.DMSCHEMA_% DMVs
User Rating: / 1
PoorBest 
Written by Vidas Matelis   
Monday, 26 January 2009 03:26

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:

DMSCHEMA DMVs

 

Tags: 2008, dmv, faq
 

Pyramid Analytics