1.7

Rating:        Based on 2 ratings
Reviewed:  0 reviews
Downloads: 191
Change Set: 7cd6b02a537d
Released: Sep 10, 2014
Updated: Sep 11, 2014 by Seddryck
Dev status: Stable Help Icon

Recommended Download

Application NBi-1.7.0.7
application, 2410K, uploaded Sep 10, 2014 - 191 downloads

Release Notes

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 ?

New features

  • Setup and Cleanup: Added support for
    • inheritance
    • parallelism
    • run-once
  • 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

About genbi:

  • 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

Bug fixes

  • 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)

What's cool

  • 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.

Reviews for this release