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:
Read more...Errors from the SQL query module: The ‘DATABASE_NAME’ restriction is required but is missing from the request. Consider using SYSTEMRISTRICTSCHEMA to provide restrictions.
Tags: dmv