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@xxxxxxxxxx> wrote in message
news:8F2A0C0D-25DA-4D93-94AE-CF2E5B28B663@xxxxxxxxxxxxxxxx
Does anyone have any ideas on how to unit test SSAS.



.

Relevant Pages

  • Re: Fairly Large Cube-Performance Improvement recommendations
    ... move) if the cube has large number of dimensions. ... We have 30 dims in the cube and the storage design wizard taked about 45 ... > 1) execute a fairly long query, let's say one that runs for 20 seconds. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... Each of the cubes have 12 partitions with monthly slices. ... Counting multiple hierarchies as dimensions, we 10 regular dimensions and 6 ... The first time we bring up the cube edit it take 1 min 20 secs, ...
    (microsoft.public.sqlserver.olap)
  • Spoof shared dimension for virtual cube
    ... just getting back into Analysis Services again, ... Two cubes, ... Cube1 has 10 more dimensions, ... I'm sure it's possible to get this result with MDX (which I'm still not ...
    (microsoft.public.sqlserver.olap)
  • How to create a "Stock" cube ?
    ... and dimensions, but now I must take it one step further and create what I ... The cube will have dimensions like: ... Itemnumber, Itemgroup, Stocklocation, Blocked, Customs classification ... Thus selecting a particular itemnumber ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube very slow to querying when in the middle of a process
    ... how many partitions are you dealing with if you add new ... >> Well, when incrementally updating dimensions, AS2k will automatically ... >> refresh the cube partitions below it which may have an impact on this. ... >> point where you may want to have reporting OLAP cubes and processing OLAP ...
    (microsoft.public.sqlserver.olap)
Loading