ORAYLIS BI. Quality - a testing suite for BI solutions (free)

Project Description:

ORAYLIS BI.Quality is a testing suite for BI solutions makes it easier to develop in an agile environment. The suite is based on NUnit and supports quite a lot of different testing methods.

Having made subtle changes or after refactoring their ETL chain, BI developers can rely on automated tests whether their processes still produce the expected figures - both using SQL and MDX.

For example it can automatically compare result sets from different sources, for example SQL and MDX. This allows to define test scenarios the system must meet after the OLAP cube has been loaded. For migration projects it can still run queries against the old system and compare the results with the new system. As everything can be automated, tests can be run on a regular basis (for example directly after every cube processing) to make sure, that all facts are really complete and correct.

Test-Scenarios

Structure tests
Data-availability tests
ForeignKey tests
Unknown Member tests
Constraint tests
Compare tests