Skip to content

v1.13

Compare
Choose a tag to compare
@Seddryck Seddryck released this 11 Aug 08:34

Release 1.13

This release 1.13 introduces a bunch of new features to assert the result-set returned by a query and a few bug fixes or improvements. This release is also supporting SSIS 2016.

This release is downloadable from there.

Version: 1.13.0.18 aka v1.13

What's new ?

New features

  • #192 Support of SSIS 2016 ... more info ...
  • #133 Use 'row-count' with a condition and support % of rows validating the condition compared to full result-set. ... more info ...
  • #148 & #59 Assert that all/no rows return by a query validate an expression (less-than, equal, more-than). A replacement, with additional features, for the deprecated evaluate-rows. ... more info ...
  • #154 Improvement in the task to start PowerBI ... more info ...
  • #166 Clean-cache is now also available for SSAS (MD and tabular) ... more info ...
  • #163 Possibility to specify that you don't need to take into account an inherited default parameter for some queries ... more info ...
  • #175 Read a connection-string from an ODC file
  • #160 Specify a timeout for an individual query
  • #156 Support stored procedures when using a report element

genbiL

  • #145 Support definition of settings in an external file
  • #194 Allow generation of tests when the list of cases is empty

Bug fixes

  • #159 In some conditions the command groupcould result in a list of string in place of an array
  • #142 If the test fails then the tasks in the cleanup element are not executed
  • #173 Rounding is invalid for negative values
  • #162 Tests of structure for relational models only work with SqlConnections (not with OleDb)
  • #164 Existing packages are not found when using the Catalog
  • #197 Tests for "schema existence" fail when schema_owner is not "dbo"
  • #193 genbiL doesn't support two consecutive comments

What's next ?

Main ideas for release 1.14 (or next)

  • Continue to support xml as a data source. The final goal is to be able to query xml files from reports (SSRS).
  • Add support for testing that a result-set has no duplicated rows
  • Support to test if rows have been added (or updated or deleted) in a table after the execution of a SQL statement or a ETL.