Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSAS/MDX Unit Testing


SSAS/MDX Unit Testing

Author
Message
Jim Mackenzie
Jim Mackenzie
Old Hand
Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)

Group: General Forum Members
Points: 350 Visits: 713
Hi All,

I've been doing a bit of searching round for ways to unit test cubes and the results seem to be limited. What we're trying to do is make sure that any releases we make to live don't alter the existing numbers, unless we are aware that this should be the case, obviously we'd then make a change to the tests.

I've been toying with the idea of creating framework using ADOMD.NET, but this appears to be limited to single result set numbers, e.g.


Select [Measures].[Total Sales Value] On 0
From [My Cube]
Where [Date].[Year - Month - Day].[Date].&[20130313]



Does anyone have any ideas? In the meantime I'll continue searching round for ADOMD.NET stuff and post back any results I find.

Cheers,

Jim.

SQL SERVER Central Forum Etiquette
Jim Mackenzie
Jim Mackenzie
Old Hand
Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)Old Hand (350 reputation)

Group: General Forum Members
Points: 350 Visits: 713
Hi All,

Just thought I'd drop a note back to say that I found some software on codeplex that can do this for you. It's called QueryUnit, which builds a dll that can be consumed by Nunit, which integrates directly with Visual Studio 2012.

So I've now set up about 30 tests for different measures and such like that executes against live to test that nothing unexpected has changed after releases.

Hope this helps someone!

SQL SERVER Central Forum Etiquette
Cédric L. Charlier
Cédric L. Charlier
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 66
Hi,

You should try NBi available at nbi.codeplex.com If you compare it to QueryUnit, it's easier to spot the difference between the expected resultset and the result of the test execution (especially with large resultset).

With NBi you can also test the structure of your cube and check that dimensions, hierarchies, measures are avilable. Other features include also the possibility to check your memebers in dimensions/hierrachies.

You can create large test-suite with this tool, on our side we've more than 2000 tests on the structure and the test-suite run without problems.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search