Follow

Release Notes for TX DWA 17.5.x

17.5.2 - Initial Release

Release Documentation 

New features

  • Redesigned user interface
  • Use SQL Azure for repository, data warehouse and staging databases
  • Direct read between data warehouse and staging databases
  • Support for Internet connection through proxy server
  • Feature deprecation

Changed

  • Better and faster conditional lookup fields
  • Configure the load date on history-enabled tables
  • More options for delete handling on history-enabled tables
  • Use type 0 fields on history-enabled tables
  • Better handling of null-value type II fields on history-enabled tables
  • Improvements to the Qlik modeler
  • Improvements to Qlik sense server integration
  • General usability improvements
  • Improvement to the AnySource adapter

Fixed

  • Add/edit related records with fixed values not saved correctly
  • Aggregation errors on cube with hidden fields
  • Changes to default field values are ignored both in raw and valid tables
  • Data movement pane appears on lookup fields
  • DB2 data source does not support SQL Server 2016 when using SSIS for transfer
  • Default value constraints don't change names if tables or columns are renamed
  • Differential deployment on a single table causes version notes to pop up twice
  • Dropdown for selecting a repository can be slow with many databases on the server
  • Exception handling in the data cleansing stored procedure
  • External SQL connection with ADO transfer fails for data types money and smallmoney
  • GUI freezes when creating databases and saving project takes a long time
  • Impact analysis crashes with stack-overflow exception when conditional lookup fields has self-referencing condition.
  • Incremental load using soft/hard delete on a Dynamics AX & NAV tables causes issues when collations are different
  • OLAP security issue with inheritance on parent child dimensions on cubes
  • Partial deployment of the stage database not available
  • Qlik doesn't detect circular references
  • Reverse OLAP issues: Wrong validation and 'The given key is not present in the dictionary' error
  • Review differential deployment tasks causes exception for mapping table with no fields
  • Securable views uses the table's data source qualifier to qualify column names on business units instead of the qualifier for the staging database 
  • SSIS package command timeout is not set for the OLE DB destination (staging)
  • Unnecessary 'Row Number' calculation in data cleansing procedure

17.5.3

Fixed

  • Changing data source option: 'Failing' does not mark the tables for as changed
  • Include in primary key jumps in the tree
  • The Save and Reload Project is not refreshing the project correctly
  • Editing field not working properly (F2)
  • Fix Deprecated Lookup Options sometimes fails
  • Edit Related Records dialog sometimes fails when opening
  • Problem deploying after upgrading from 14.5.8 to 17.5.2
  • Generating Documentation for External Business Unit

17.5.4

Fixed

  • GUI Performance improvement for big projects
  • Wrong update of tree when using drag and drop
  • NAV native data type problem using SSIS
  • Edit Related Records dialog cleans all conditions on old source table on change
  • Plugin issue when Reload project is returned from a plugin

17.5.5

Fixed

  • Delete of Users in a database role and in OLAP server roles will delete on No
  • Progress ODBC data source does not apply date out of range conversion for SSIS
  • AX/NAV - incremental load with soft delete - SSIS disabled issue
  • Nav/Ax fail datasource ignored issue
  • Multiple environment transfer and deployment perspective issue
  • Project Perspective: User defined functions and stored procedures naming are wrong
  • SQL Azure, problem with extended properties
  • Deploying securable column fails due to a UI error
  • Measure folder - F2 rename problem
  • Dragging data movement nodes to a field in a data warehouse selects wrong node
  • The "move down" command in the menu does not work anymore
  • UI not updating when adding a custom selection rule on a data warehouse table
  • Nav adapter multi environments transfer OverrideDataType issue
  • Adding all tables to hard deletes in the incremental selection wizard
  • Error when trying to remove adapter table from full load list in execution package
  • Execute table with conditional lookup from external SQL connection fails
  • Allow global sql database with more than 13 characters in the name
  • Corrected step count on execution package containing external step
  • UI crash execution steps dialog
  • Update of project tree when using drag & drop
  • Dynamic CRM - Global database - SSIS approach issue

17.5.6

New features

  • Easier selection of advanced "Schema Properties" in OLE DB and ADO data sources

Fixed

  • AX adapter with Oracle datasource open project error
  • Edit data type on Hierarchy tables gives an error
  • Documentation field Copy issue
  • AX/NAV - Primary key table not created on simple mode incremental load
  • Incremental load with hard deletes on table with renamed fields
  • ODBC Connector additional properties
  • Query table with raw fields issue
  • Dynamic CRM synchronize float datatype issue
  • Drag and drop to switch node positions sometimes sets the scroll position to its bottom position
  • External SQL connection on DWH can cause object null reference
  • Advanced Dimension Editor (ADE) does not show any thing in version 17.5.

17.5.7

Fixed

  • Replace Jet Metadata DLL - options handling
  • Full load objects on Execution Packages are faulty after an 'Save As'
  • Wait dialog does not close in all scenarios
  • Query Tool error when text in cells exceeds 32000 characters
  • Micorsoft.SqlServer.Types.dll should be loaded in version 2016 or later
  • Olap Access Control: Changing Role type to "Combined" fails with null reference exception
  • Loading tree for data sources with more than 10 000 tables fails

17.5.9

Fixed

  • Database roles are not saved on add
  • Save as fails when having a project with invalid full load objects
  • Valid table recursive reference check still too slow
  • CAST in lookup joins when joining decimal columns 

17.5.10

Fixed

  • B00810 AX/NAV has wrong destination table for primary key delete on additional adapters using ADO
  • B00808 SQL2008 not working with incremental load hard/soft deletes when using SSIS
  • B00807 AX/NAV - Soft/Hard deletes doesn't work after version 17.5.4
  • B00805 Ordering of conditional lookup fields
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.