SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:10 PM
| ||||
| ||||
 Re: Unit Testing 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" <nospam@nospam.com> wrote in message news:8F2A0C0D-25DA-4D93-94AE-CF2E5B28B663@microsoft.com... > Does anyone have any ideas on how to unit test SSAS. >      |
Linear Mode
