Report Portal

SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs

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: dmv

 

2007-2015 VidasSoft Systems Inc.