What are SSAS DMVs?
User Rating: / 2
Written by Vincent Rainardi   
Friday, 01 January 2010 18:10

SSAS Dynamic Management Views are Analysis Services schema rowsets exposed as tables that we can query using T-SQL SELECT statement. For example, to query discover_connections DMV, we can write:
select * from $system.discover_connections

DMV is more convenient to use than schema rowsets, because:
a)    we use SELECT statement rather than XMLA
b)    the output is a table rather than XML




Tags: article, dmv

Pyramid Analytics