Good question!
Its difficult to identify 'units' that could be tested - as so many of the
components (ie dimensions) are shared - so that ultimately there's not much
difference between a unit test and a system test. Projects I've been
involved with tend to test the cube by rendering the reports and checking
the figures therein.
Having said that ways in which you might consider testing a cube are:
1. Full process - sounds obvious but a lot of problems are idenitified by
processing the cube. I suppose this is roughly equivalent to compiling
source code.
2. Validating structure using XMLA - ie checking partitions and more obvious
stuff such as measures, dimensions etc.
3. Loading/restoring a 'known' set of data into your relational source,
processing, and querying using MDX. If you wrote enough queries you could in
fact do most of 2. this way.
All of this could be automated in SSIS of course.
I'm not aware that there are any additional tools available to assist in
testing a cube.
HTH
--
Phil
http://www.clarity-integration.com
http://www.phil-austin.blogspot.com
"Fresno Bob" wrote in message
> Does anyone have any ideas on how to unit test SSAS.
>
FAQ
Search
Profile
Private Messages
Log in
