Jens Vestergaard shows how to test Analysis Services cubes using a Visual Studio test project:
Unit testing in Visual Studio is actually not that hard and can save you a lot pain down the road. The testing framework in Visual Studio offers extensive ways of executing batches of tests. You can group tests by Class, Duration, Outcome, Trait or Project.
When you right-click a test, you get the option to select how you want the tests in the Test Explorer to be grouped.
If you have an Analysis Services cube, definitely read this—testing is a vital part of software development, and automating tests can save you significant time later.