SSAS Articles SSAS 2008 SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs
SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs
User Rating: / 0
PoorBest 
Written by Vidas Matelis   
Saturday, 07 June 2008 04:33

In my previous post Katmai Analysis Services 2008 November CTP5 - tests on metadata rowsets i listed examples of new SSAS DMVs. But there were few DMVs that you could not query. For example if you would try to execute following query:

SELECT * FROM $SYSTEM.DISCOVER_PARTITION_DIMENSION_STAT

You would get this error message: 

The ‘DATABASE_NAME’ restriction is required but is missing from the request.

In the SQL Server 2008 RC0 when you execute the same query, you will get this error message:

Errors from the SQL query module: The ‘DATABASE_NAME’ restriction is required but is missing from the request.  Consider using SYSTEMRISTRICTSCHEMA to provide restrictions.

Read more...
 
Tags: 2008, article, dmv

Strategy Companion