Assuring Database Availability and Consistency
Analysis Services DBAs have SSMS and XML for Analysis (XMLA) scripting language for managing databases. You can create, alter, process, and drop databases through SSMS or through XMLA scripts. We also have the ascmd command-line utility that we can use to automate server connectivity checks and for querying/processing of MSAS objects. Sadly Microsoft doesn’t provide any utility for checking database consistency. Instead, you could periodically submit simple queries to each cube on your server to make sure that it is query-able. SSMS allows scripting each object as well as majority of administrative commands in XMLA format, which makes learning the XMLA language straightforward.