Checking whether cubes are accessible
Microsoft does not provide any database consistency checker (DBCC) command for SSAS. However, this does not imply that Analysis Services objects could never get corrupted. In order to assure whether your cubes can be queried, you can set up a job that periodically runs very lightweight queries against each cube within your SSAS plant.
How to do it...
- To check whether your cubes are available for querying, you could use the ASCMD utility to run a query similar to the following:
WITH member measures.is_accessible AS "1" SELECT measures.is_accessible ON 0 FROM [adventure works]
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
