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]
