NBi Changelog

What's new in NBi 1.7.0.7

Sep 12, 2014
  • 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)

New in NBi 1.6.0.4 (Jun 30, 2014)

  • New features:
  • Testing of ETLs: successful runs, performances and side effects of an Etl
  • Inheritance of categories from the group of tests
  • Property (properties) are now part of the structure testable through NBi
  • About genbi:
  • Adding an option to filter a set of test-cases based on the value of a column (also available in genbiL).
  • Add the possibility to load a set of test-cases based on a query (Mdx/Sql) in place of a CSV file.

New in NBi 1.3.1.26 (Jan 6, 2014)

  • Bugs fixed:
  • Comparaison of resultSet, returns twice the actual value when values don't match and you're using an interval.
  • Assertion "EqualTo" doesn't work if the first row of the expected resulSet contained a cell defined as an interval.
  • Unexpected message 'Nothing found' in the investigation of the test failure when a ContainConstraint is failing even if the content wasn't empty.
  • Minor improvements (in Genbi):
  • If there is no exclusion inside an xml element named members, the xml element exclude is not serialized anymore
  • If an xml element named ordered is provided and the descending is set to false, the xml attribute descending is not serialized anymore
  • If there is no rule-definition for an xml element named ordered then this xml element is not serialized anymore.

New in NBi 1.3.0.13 (Dec 9, 2013)

  • Enhancements and new features:
  • Performances have been improved with an option to execute two queries to be compared in parallel. Previously, if both of them needed 5 seconds to deliver their result-sets, the test would take around 10 seconds. Now, the two queries are executed in parallel and resulting in a test executed in 5 seconds.
  • Usage of parameters to provide values to a query
  • Usage of template-variables to update dynamically a query
  • You can compare your hierarchy's members to a dynamic list of members retrieved by a query. Meaning that you can compare the result available in your cube to a SQL query on your source-system.
  • A test to check that members'caption of a hierarchy or level are matching with a regular expression
  • Added a feature to compare values in a result sets to a range of values (intervals) and not to a unique value.
  • The opportunity to define a tolerance for dateTime value columns
  • Added a feature to define a tolerance in % of the expected value (for numeric columns)
  • Added a feature to define a tolerance based on rounding option (for numeric and dateTime columns)
  • Added a feautre to compare a value to a generic value named (any). This generic value accept null and not null values.
  • "yes" and "no" are now valid values for a boolean
  • You can group your tests in the xml test suite. When editing your xml, you can toggle the group to display or hide the set of tests grouped. This feature has no influence when executing the tests.
  • The possibility to move a column at left or right in Genbi
  • We've improved the user-experience when analyzing the reasons of a failed test when running tests on members.
  • Genbi lets you select some tests and add easily a category to them
  • Bug fixes:
  • A few user-experience enhancements in Genbi and a few bugs found in Beta1, Beta2 and RC
  • A bug about usage of element measures and attribute display-folder in the same test.

New in NBi 1.3.0.6 RC (Nov 8, 2013)

  • Usage of parameters to provide values to a query
  • Usage of template-variables to update dynamically a query
  • A test to check that members'caption of a hierarchy or level are matching with a regular expression
  • The opportunity to compare values in a result sets to a range of values (intervals) and not to a unique value.
  • The possibility to move a column at left or right in Genbi

New in NBi 1.3.0.4 RC 1 (Oct 7, 2013)

  • Enhancements and new features:
  • Performances have been improved with an option to execute two queries to be compared in parallel. Previously, if both of them needed 5 seconds to deliver their result-sets, the test would take around 10 seconds. Now, the two queries are executed in parallel and resulting in a test executed in 5 seconds.
  • You can compare your hierarchy's members to a dynamic list of members retrieved by a query. Meaning that you can compare the result available in your cube to a SQL query on your source-system.
  • We've improved the user-experience when analyzing the reasons of a failed test when running tests on members.
  • You can define a tolerance for dateTime value columns
  • You can define a tolerance in % of the expected value (for numeric columns)
  • You can define a tolerance based on rounding option (for numeric and dateTime columns)
  • We've added the possibility to compare a value to a generic value named (any). This generic value accept null and not null values.
  • yes and no are valid values for a boolean
  • You can group your tests in the xml test suite. When editing your xml, you can toggle the group to display or hide the set of tests grouped. This feature has no influence when executing the tests.
  • Genbi lets you select some tests and add easily a category to them
  • Bug fixes:
  • A few user-experience enhancements in Genbi

New in NBi 1.2.0.17 (Sep 23, 2013)

  • After the load of an existing test suite, it was possible to display the tests but as soon as you was trying to add new ones, the existing tests were removed. It's now fixed and you can add tests to an existing test suite.
  • When saving a previously existing test suite, the defaults and references were copied to the system-under-test tag and the test suite had an invalid format. It's now fixed and the elements are not copied anymore.
  • Usage of "Use grouping" option was a bit random. It's now fixed and if you check the box, the expected generation will be executed.

New in NBi 1.2.0.12 (Sep 17, 2013)

  • Enhancements and new features:
  • In addition to SQL and MDX queries, NBi is now supporting DAX queries
  • New items to support the testing of structure for Tabular model (in addition of existing items for multi-dimensional model)
  • Performance improvements when comparing two result-sets (especially for large result-sets) - Thx to NonExplodingBiped
  • Possibility to exclude some dimensions' members for a test of membership
  • Support for Boolean and DateTime types in addition to Numeric and Text fields
  • Support of two new placeholders (value) and (empty) for pre-defined result-sets
  • Improved some error messages
  • Trace management (NBi lets you the opportunity to receive more or less messages in the Trace Output ... tests are faster if you decrease the tracing)
  • UI improved for Genbi
  • You can open an existing test-suite in Genbi (To add new tests)
  • Create project files (gallio or NUnit) from Genbi
  • Bugs fixed:
  • Genbi is fully operational
  • Added some trace messages

New in NBi 1.2.0.4 RC1 (Jul 26, 2013)

  • Enhancements and new features
  • In addition to SQL and MDX queries, NBi is now supporting DAX queries
  • New items to support the testing of structure for Tabular model (in addition of existing items for multi-dimensional model)
  • Performance improvements when comparing two result-sets (especially for large result-sets) - Thx to NonExplodingBiped
  • Possibility to exclude some dimensions' members for a test of membership
  • Support for Boolean and DateTime types in addition to Numeric and Text fields
  • Support of two new placeholders (value) and (empty) for pre-defined result-sets
  • Improved some error messages
  • Traces management (NBi lets you the opportunity to receive more or less messages in the Trace Output ... tests are faster if you decrease the tracing)
  • UI improved for Genbi

New in NBi 1.1.0.27 (Jul 26, 2013)

  • Enhancements and new features:
  • Test availability of one or more elements in the cube structure
  • Test the relation between a dimension and a measure-group
  • Test availability of one or more members in a hierarchy or level
  • Manage connection strings (defaults, references and values provided by config file)
  • Get a query from an assembly
  • Several enhancements to facilitate the diagnostic of common issues with NBi files (missing connection, csv files with headers, incorrect formats for numeric columns, ...)