SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

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.