The release 1.7 includes a set of new, tiny but useful, features to be more efficient when creating test-suites. About Genbi, we've added a feature to filter on distinct rows and the support of "if" statements in the template. GenbiL, the macro-language, is now supporting comments. We've also fixed a set of bugs thanks to reporters.
Please report all the bugs to the issues tracker
to ensure they are fixed ... even if they are minor issues.
What's new ?
- Setup and Cleanup: Added support for
- Support of Shared Datasets when extracting queries from SSRS
- Settings in an external file
- DTD Processing
- Tables to compare result-sets are now in Markdown
- When comparing sets of members or structure's elements, the lists of missing/unexpected elements are now also in Markdown
- Added an option to filter a set of test-cases to only have distinct test-cases.
- Added a way to use the "if" statement in the template.
- genbiL supports the filter distinct instruction and comments
- Etl runs from the Catalog (SQL Server 2012 and 2014) wasn't supporting parameters
- Setup's command etl-run wasn't reporting the failures of the Etl.
- Details of the exception thrown after an error during a test's execution was removed in some cases.
- The value of defaults in settings was not always correctly applied when they are specified in a genbiL script Bug #25
- Commands were executed in the reverse order for setups
- The root path of the table-load command (Setup/cleanup) was not aligned to the path of the test-suite.
- SSRS parsing (for files) was limited to SQL Server 2008 and 2008R2 (Now suports all versions)
- A session about testing BI solutions with NBi will be presented at SQL Saturday at Paris the 13th of September by Cédric L. Charlier.
- Davide Mauri has enlisted NBi as a testing tool during his session at 24hop about Agile Data Warehousing and a blog post.
What's next ?
Main ideas for release 1.8 (and next)
- Execute tests with etls running on a remote server.
- Add a setup command to run sql script or batch.
- Add a setup command to run some executables.
- Add a setup command to process parts of a cube (SSAS).
- Support some tests about result-sets, to express easily conditions such has "If this field is greater than X then this other field must be greater than Y".
- Support tests on the xml of a report (SSRS)
I'm (still) working on a Release 2.0. This work is delayed to the lack of releases for NUnit 3.0 (and changes in the API). Anyway the goals are still:
- Lot of internal refactoring meaning easier to integrate new features (mostly done)
- Compatible with NUnit 3.0 meaning easier to setup a test suite !
- Easier to port it to another test framework than NUnit (xUnit, Fixie, ...)
- Easier to write helpers to compare result-sets
- Easier to create a Visual Studio Add-in
Naturally this Release 2.0 has a big constraint linked to the availability of NUnit 3.0 (currently still not available) so no planned date for the moment.