Administering and Monitoring Analysis Services - SQL Server Analysis Services 2012 Cube Development - page 285

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...
1. 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]