Jet Analytics Build 20.10.42.64
Release Date: April 14, 2023
New and Improved Features
-
Upgraded .NET Framework versions. (4886)
-
Jet Analytics is now compatible with Business Central version 22. (3892, 4624)
-
Enhanced the Jet Analytics install file by displaying the build number in the .zip file name. (3691)
-
Removed Legacy BC Extension from install folder and moved to BC Extension download folder. (3695)
Resolved Issues
-
Corrected an issue when a “Too many Requests” error was return from BC terminating the project, Jet Analytics now retries instead of fails. (4000)
-
Corrected an issue when using OAuth Authentication causing a null exception error. (4090)
-
Corrected error messaging when authenticating with Dynamics 365. (5051)
Release Date: December 20, 2022
New and Improved Features
- 3086, 3852, 3869,3870, 4082, 4267 : Implemented NAV Adapter to avoid duplicate tables
- 3982, 4144, 4396, 4435: Update BC Extension to Support latest version of BC
Resolved Issues
- Corrected an issue where in some cases, users would encounter an error when executing and deploying a data table. (4139)
- Corrected an issue where project execution would fail in cases where a user had multiple BC365 data sources configured to use OAuth authentication. (4143, 4170)
- Corrected an issue in Business Central where running a report with a table that contained more than 100,000 records would cause an error to occur (4159)
Jet Analytics Build 20.10.33
Release Date: August 9, 2022
Please install the latest BC Extension (version 1.0.0.32) to utilize 20.10.33 version of Jet Analytics.
You can find the latest BC Extension in App Source for BC Public Cloud or on the insightsoftware downloads page for BC On Prem.
For More information about the BC Extension Update, see the table at the bottom of this page.
New and Improved Features
- 3692, 3693, 3696, 3697: Improved performance of Web Services when using Jet Analytics with Business Central.
- 3732: Modified on-premises versions of Business Central extensions per MS "Universal Code" initiative.
- 3848: Improved security related to Jet Analytics URLs.
Resolved Issues
- Corrected an issue where managed deployment in multiple environment transfer would not display an error message upon receiving an error.
- Corrected an issue where Global DB would not save changes for Oracle data sources
- Corrected an issue where “Save As” would not update distribution columns with the updated id.
- Corrected an issue where in some cases users would receive an out of memory error after closing the Deploy and Execute dialog.
- Corrected an issue where in some cases, the wrong project version would open when loading the deployed version of a project.
- Corrected an issue where the application would sometimes freeze up when adding objects to the execution queue.
- Corrected an issue where in some cases the “sort order” would revert after testing connection in the environment.
- Corrected an issue related to validating the numeric scale when deploying a decimal field in the data warehouse.
- Correct an issue where in cases where the execution tree in the dialog was too large, the application would crash.
Resolved Issues (ODX)
- Corrected an issue where the activity timeout setting was missing from the global database setup, and the setting was ignored when transferring data from the ODX to MDW with azure data factory.
Jet Analytics Build 20.10.30
Release Date: May 5, 2022
New and Improved Features
- 3312: Implemented a new authentication method called "Client Credentials" that does not use tokens that will eventually expire, thus eliminating the need for re-authentication at that time.
- 3637: The BC/NAV adapter (SQL Provider) will now work with versions prior to BC 16 (e.g. CRM tables).
- 3499: Made performance improvements:
- Updated algorithm to improve overall performance.
- Added logging to assist with troubleshooting.
- Updated the TCP Keepalive setting to mitigate risk of issues that could result from Microsoft updates.
- 14049: Support for Service to Service authentication for Business Central 365 provider. The provider now supports Service to Service authentication.
- 13577: Updated ODX Oracle ADF data source to better support old versions of oracle.
- 12729: It is now possible to select a batch size when creating or editing a SQL data storage.
- 12488: Schedule Dialog re-design
- 11048: Updated global databases dialog to increase password security
- 12377: Added shortcut to Windows start for easier access to the configuration tool.
- 12101: Segmentation of ODX ADF data source executions. Improved Azure Data Factory execution to better support data sources with a large amount of tables.
- 12194: Added ODX Sandbox support
- 12100: Replaced ODX direct synchronization on ADF data sources. Improved the ODX Azure Data Factory logic so the ODX no longer needs to connect directly to the data source when reading meta data
Resolved Issues
- 3761: Corrected an issue where in some cases data was returned with missing tables when the total number of fields (across all tables) in the BC instance exceeded 100,000.
- 3567: Corrected an issue where duplicate data was being uploaded to the staging table when the number of records being queried exceeded 100,000.
- 11046: Field Transformation panel manipulates the input
- Fixed issue with input field sometimes wasn't updating the UI correctly for field transformation
- 11322: Script parameter mapping does not pickup renamed mappings
- Renaming an object in a script and then dragging the same object into the script again, would cause the second mapping to ignore the rename and just add it as a new mapping with the original name instead of reusing the first mapping and use the renamed value. This has been fixed, so when dragging in an object for the second time, then it will always use the value of the first mapping.
- 11394: Notification should have the bell as an icon for eventlog types
- Fixed incorrect icon for event log notifications
- 11450: Wrong icon for raw only system fields
- Fixed issue where the wrong icon was used for raw only system fields
- 11478: Object-level security on raw only fields fails
- Fixed issue with raw only fields and object-level security
- 11523: Uneven mapping count issue
- Fixed issue with calculating mapping count for uneven mappings
- 11772: Encryption on Global DW and Stage ConnectionStringProperties causes a corrupt repository
- Fixed an issue where the upgrade from 20.10.21 to 20.10.22 would leave Global Staging and Global Data Warehouse databases in an invalid state
- 11556: CData engine uses incorrect quoting for query table & query tool
- Fixed issue with quoting in the query tool and query tables
- 11459: Use the "confirm password" pattern in ODX Configuration tool
- Updated the pattern of setting up passwords in the ODX configuration tool
- 11683: Issue with empty username in ODX notification
- It was not possible to leave the username empty in the notification dialog
- 11908: Synchronize ODX objects does not update indexes
- fixed issue with suggested indexes on Valid for tables mapped from an ODX
- 11583: MDW/SSL: It is possible to execute steps for old project versions in the execution queue
- Fixed issue where objects from old project versions could be deployed in the execution queue
- 12055: Task count ignores deployment step selection when choosing to only deploy modified tables and views
- Fixed issue where deploy/execute dialog has incorrect check states in object tree view
- 11695: Business Central 365 - can only execute with two web requests at a time
- This has now been fixed. It will follow the number of threads an execution package runs in but since the execution is multithreaded and an execution can contain multiple execution packages running at the same time the number of web requests will be the highest "Max. Threads". When an execution package completes then next "Max. Threads" will be used if more execution packages is running.
- 12243: Business Central 365 SQL Provider - Read object issue when server and database collation conflicts
- A collation issue was fixed when extraction database structure from a Business Central 365 SQL Server database
- 12067: SAP Data Source force DATS data type to datetime2
- This is now optional and it is possible to choose SQL DateTime2, SQL DateTime and SQL Date. Default is SQL DateTime2
- 11894: SAP Data Source adds 1 extra precision for decimal data types
- This has now been fixed. An option to force all decimal data types to a precision of 38 has been added.
- 11989: SAP Adapter does cannot set "Extract data in background job"
- This has now been corrected.
- 12035: Continue with Existing data deletes all records when table is Incremental loaded and with Use hard delete is enabled
- This has been corrected. The error that caused a failing data source is now added to the execution message which is used for notifications and it can also be found in the execution package log history.
- 11875: High memory usage when executing a Data Warehouse
- This was caused by the way foreign key relations was checked, dropped and created. This issue was also present if no relation with type "Error - with physical relation" was present in the project.
- 12253: Issue with TimeXtender.DataManager.TXForm.AdjustForInvisiblePanels()
- Fixed an issue where scaling a form would crash the application. (AdjustForInvisiblePanels())
- 11724: Staging database menu decreases in size every time you open it if you have Window sizes set to remember always
- This got fixed when the option to remember windows sizes was removed.
- 12004: Executing CData rest provider in multiple environment transfer dialog is not working
- Fixed issue with rest data source when execution a remote server project in the multiple environment transfer dialog
- 12045: Executing data export tables in the execution queue fails with null reference error
- Fixed issue where executing data export tables in the execution queue failed
- 12072: Issue with deploying data cleansing procedures in the multiple environment transfer dialog
- Fixed issue where conditional lookup fields were sorted incorrectly for data cleansing scripts when deploying objects in the multiple environment transfer dialog
- 11692: Plain text connection string is available when setting up data sources in property grid
- This is now hidden. An option import and export a connection string has been added.
- 12183: Issue when adding incremental rules to tables in a business unit
- When creating an incremental rule and you select a field and right after deselect the field, the table was not marked as incremental.
- This has been corrected
- 12248: Find (CTRL-F) does not search in Custom Table Insert scripts
- This has been corrected
- 11741: ODX email notification UI is acting strange
- Updated UI for ODX notifications on critical errors
- 11609: Error when opening properties of a ODX SQL store
- Fixed issue where reading database properties of ODX SQL storage failed
- 11992: SAP Table CDS ignores "Activate Background Extraction" setting when generating SSIS package
- This has now been corrected.
- 11731: ODX to Data Warehouse transfer never transfer batch numbers when using "Limit memory use" on the ODX
- 11681: Timer in ODX tasks resets after 24 hours
- This has now been corrected.
- 11952: Issue with incremental load on query tables without subquery enabled
- Fixed issue where query tables in the ODX didn't work with incremental load when use subquery is disabled
- 12494: Data Warehouse tables with incremental load and delete handling does not truncate the primary key table (_PK)
- This has been corrected.
- 12455: ADF version 8.1.0.0 is not supported in ODX versions prior to 20.10.24
- version 8.1.0.0 has been removed and version 9.0.0.0 has been introduced.
- 12109: Allow ignore of mail server certificate errors on "Notification on Critical Errors"
- This is now possible with the option "When using TLS" and setting this to "Allow invalid certificate".
- 12567: Incorrect Accent grave sign in General ODBC setup
- The Accent Grave type was character ' this has been changed to `. ODBC connections using the Accent Grave are update to use the new Single Quot.
- 12650: Scaling issue with 'Select fields'
- This has been corrected.
- 12563: SSIS settings are not remembered in ODBC data source
- This has been corrected.
- 12588: Field display is missing space in 'Project Variables'
- This has been corrected.
- 12607: Project Variable script window radio buttons - switch between 'Translation' and 'Value Translation' doesn't properly work
- This has been corrected.
- 12653: Scaling issue with ODX Query Tool
- This has been corrected.
- 12489: Add Data Source: Copy/Paste is not working correctly for Name / Short name
- This has been corrected.
- 12807: BC 356Support for multiple selection rules
- BC 365 provider now supports multiple selection rules.
- 12698: Issue with ODX Alert notification logic
- Fixed issue where some cloud secret and other connection errors would not generate mail notifications.
- 13038: Changing the source table of a table insert does not remove selection rules
- Fixed an issue where changing the source table of a table insert would not remove selection rules depending on the "old" source table.
- 12735: Setting simple mode on table does not clear L and M tables
- This issue has now been resolved.
- 12650: Scaling issue with 'Select fields' dialog
- Source table columns now scale correctly.
- 13513: Unreadable text in "Wait dialog"
- We updated the UI, and will not show the text and not a black line when the text is to long.
- 12881: Stored procedure missing in custom view and custom table insert menus selection area
- This has now been added.
- 13594: Failure when trying to delete a conditional lookup with dependencies to a custom selection rule on a data warehouse table mapping
- Fixed issue when trying to delete a conditional lookup that has dependencies to a custom selection rule on a data warehouse table mapping.
- 13049: "When transfer fails" setting is not returned correctly for AX and NAV adapter
- The setting was read from the wrong source and it has now been corrected.
- 12758: Custom Views: Table Parameter Variant is inconsistent
- The variant now default to 'Valid Table'.
- 13402: Import Connection String option is missing in Global Databases for CData sources, Any Source ADO and Any Source OLEDB
- Added option to import and copy connection string when setting up global ADO, OLEDB and CData data sources.
- 3101: Issue with Advanced Dimension editor
- When running the Advanced Dimension Editor the end user was meet with the error: Could not load file or assembly 'TimeXtender.Jet.API, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.......
- This was caused by a wrong build configuration of the product. This has now been corrected.
- 13423: It is possible to Import connection string when a global database is selected (CData ,Any Source ADO, Any Source OLEDB)
- Fixed UI error when import connection string was enabled when using global databases.
- 13055: Notifications on errors do not work when happening on an additional data source
- This has now been fixed.
- 13396: Pre/Post scrips fails to load when applied to Step Transfer for a custom tables with customized SSIS package on business unit
- When deleting a custom SSIS package from a custom table on a business unit the pre- and post scripts was not removed from the Deploy and Execute transfer steps. This has now been corrected.
- 13529: Inconsistency in Global Database Any Source OLEDB
- Fixed issue with global OLEDB data source where changing the provider or connection string value would not updated the UI correctly.
- 13336: AX and NAV adapter sync. problem
- An issue was resolved when a field used as primary key was removed during synchronization of the adapter.
- When the error occurred a message was displayed saying "Deleted row information cannot be accessed through the row."
- 13135: Wrong FiscalDayOfYear in Date Table
- This has now been corrected.
- 12821: ADF supports changing of authentication type, but only one type is supported
- We removed the option so it will not confuse the end user.
- 12284: Timeout missing for data factory transfers
- It's now possible to set the timeout as hours, days or weeks. Default is 7 days.
- 13403: Import Connection String option is missing in database addition wizard on ODX
- Added option to import connection string when adding ADO, OLEDB and CData data sources in the ODX.
- 13200: Issue with batch number in ODX to data warehouse transfer
- Fixed issue with cleaning up duplicate data in raw table when moving from an ODX data lake to an on-premise SQL database with azure data factory with selection rules in the data warehouse destination table.
- 13230: Issue with Json version in configuration of TXIntegrationServices
- Fixed issue with Json version used for transferring SSIS data for sap data sources in the ODX.
- 13031: ODX Configuration Tool is setting wrong proxy password on rerun
- The correct proxy password is now used.
- 12729: ODX: issue with log size when using SQL storage
- It is now possible to select a batch size when creating or editing a SQL data storage. Fixed issue where a SQL storage would be created with a wrong collation and recovery mode.
- 13465: Uneven mappings fails when using a dot in table name with two or more source tables
- An issue was fixed where a data warehouse table with two or more source tables and with an uneven mapping of the source tables would create a wrong bulk copy view. Execution of the table would fail in data transfer when SSIS and Direct Read is not used as transfer method
- 13810: ADF version 9.1.0.0 doesn't work with older versions of TimeXtender (Prior to 20.10.27)
- This issue was resolved. Note: The option to use ADF in version 20.10.27 is no longer available.
- 13571: Frame does not align with grid in Add/Edit CData data source
- The data grid in the 'Edit CData Data Source' window now scales along with the frame.
- 13800: Scaling issue in Add field dialog
- Checkboxes in the 'Add Field' window should now be scaled correctly between 100-250%. The window should now also become a little taller in order to accommodate all checkboxes.
- 13852: Scaling issue in Advanced Settings in Add/Edit Data Warehouse dialog
- The activity timeout 'numeric up down' component should now scale correctly when going at 250% windows scaling or above.
- 14125: Scheduler sometimes starts packages twice
- There have been issues with the scheduler where it would start the same execution package within a few minutes. This should now be fixed so it's not possible anymore.
- 13857: First Character transformation is limited to 100 characters
- Updated First and Last characters in field transformation to support up to 2147483647 (int max) characters instead of the limit of 100
- 13672: Issue with deletes in additional data sources in BC Adapter
- Fixed an issue where additional connections would not get their _PK table truncated and therefore data that should have been deleted was still present.
- 13962: SAP Table Adapter - wrong conversion of D16D, D16R, D34D and D34R data types
- An issue was fixed where the interpretation of SAP data types D16D, D16N, D16R, D16S, D34D, D34N, D34R and D134S was wrong. They are now the corrected to be mapped to binary data type.
- 13974: Issue with filtering corrupt data when moving data from ODX SQL Storage to Data Warehouse
- Fixed issue with filtering of batch number when moving data from an ODX SQL Storage to a Data Warehouse
- 13878: Issue with ODX Execution items staying in "Pending" state
- Fixed issue where stopping an execution in the ODX execution queue would not update the UI.
- 14283: BC adapter SIFT option issue when using BC365 provider
- When changing the provider from a SQL provider to a BC365 provider the SIFT option gets disabled and left with the value from when the provider was a SQL provider. This has now been fixed.
- 14219: Incremental selection rule values are not updated correctly with +1 incremental rule
- Fixed an issue where having multiple incremental selection rules would result in data in the _I table to become incorrect.
- 14286: Out of memory exception when doing differential deployment on large projects
- If a lager number on tables are marked as modified and the differential deployment resolves them as not modified could cause the update of the tree view to fail with and out of memory exception. This has now been fixed.
- 14262: Sap - Wrong conversion of data type RAW
- An issue was fixed where SAP raw data type would double the length causing the SSIS package to fail on execution.
- 14183: Mapping in custom measure issue
- Custom measures would lose their mapping on a project close if the mapping was a custom field.
- 13861: Data source column names can become too long
- Fixed an issue where using a SQL Data Storage and having a data source with column names longer than 128 characters, would result in an error, as the maximum column name in a SQL server is limited to 128 characters.
Jet Analytics Build 20.10.26
Release Date: December 9, 2021
New and Improved Features
2113: Added OR clauses when more than one data selection rule is used.
Resolved Issues
3396: Able to synchronize data source with non-standard collation without error.
Jet Analytics 21.2.3 Build 20.10.22.64
Release Date: August 25, 2021
New and Improved Features
Added the ability to select OAuth2 Authentication for BC Adaptor (2240)
Resolved Issues
2632: Corrected an issue when using a direct SQL connection to show all enumeration option values for option tables and any extensions that have added custom enumerations.
3232: Corrected an error when Executing a table which includes fields where the “Display Name” differs from the “Database name”
3280: When viewing available translations on a new data source, the translations window populates with available languages.
8606: Business Central adapter: Username and password cannot be changed
8765: Cannot deploy primary key delete SSIS package when the data source is bit specific
8767: 32/64 bit execution engine stalls on deployment and execution when failing on initializing communication.
8811: Data Source Excel leaves out columns with type LongVarWChar - text column with more than 255 characters
8863: Error generating Super Natural Key on SQL Data Warehouse
8889: Oracle slow synchronization - affects all bit specific data sources
8892: Timextender memory leak - an issue on data source explorer
8925: SQL Data Warehouse has slow performance with identity insert, when using insert into a table - Data Cleansing
7884: "Cloud Repository is corrupt" is reported if the ODX is unable to reach the cloud repository
8850: "Specified cast is not valid" exception is thrown when the backlog was successfully created but the firewall blocked the request to add a project
8907: Azure Data Factory transfer to Data Lake can give an error: "Token has expired"
8911: Incremental load on decimal datatype is not working
8980: Qlik Sense terminate execution issue
8551: Oracle fails when using date fields as incremental load in ODX on OLE DB version
8907: ADF to ADLG2 token expiry issue
8959: Parquet and datetime2 issue
9017: Execution package with retries can return "Broken pipe" error
9039: Issue with execution package with retries
9033: ODX Parquet transfer can use all memory on large transfers
9118: ODX upgrade issue
9115: Table transfer from ODX to DWH fails when ODX table contains a DWH system field name
8659: Error when opening the errors menu when a table contains Geography data
8719: ODX tab closes on F5 (refresh)
9238: Having a Tag on a field mapped to ODX and ODX synchronizes will cause an error
9259: Issue with setting process affinity for more than 16 cores
8266: ODX Config allows you to enter project names of invalid length
9274: Azure access tokens are sometimes not refreshed and expire after an hour causing transfers to fail
9289: Database cleanup recognizes Semantic Security Table after schema change
9287: Azure access token timeout when transferring from Lake to DWH
9337: ADF SQL source incremental load value loses precision for datetime2 where precision is above 3
9344: Incremental load loses precision for datetime data type when the source is an ADF type
Numerous issues with windows and UI elements, that did not scale correctly with display scaling set to more than 100%, has been fixed. The application should now be fully DPI aware and usable on modern systems that default to a higher display scaling factor.
9228: Increase TIMEXTENDERTABLESCHEMA.FIELDHELPTXT to nvarchar(4000)
9428: NAV BC365 wrong conversion of DATE data type
9453: Nav query table - data type varbinary becomes unknown data type
9481: TimeXtender crash if you rename an execution package to an existing name
8969: ODX SAP DeltaQ delta load
9291: ODX get unresponsive when having a lot of execution logs
9457: ODX - temp folder is used for generating file names and will eventually get filled up
9001: Application secret is now obscured in the Global Database settings of the DWH Application secret in the user dialog for Global Database setting for DWH was in clear text
9538: SQL DWH - Conditional lookup is now correctly cast to the destination data type
9550: Updated logic to support table inserts from views on Analytics SQL Pool
When inserting data into a table from a view the databases on the Analytics SQL Pool platform do not support default values. Therefore the script has been adjusted to include getutcdate() as the value for [DW_TimeStamp] if such a column does not exist in the view.
9539: SQL DWH - Grouped None aggregated conditional lookups would look up the first lookup field for all lookups
The Data Cleansing script for MDW Tables on Analytics SQL Pool with multiple lookup files would only lookup the first field when the Lookup Aggregate option was set to None.
9575: Supernatural keys based on transformed values now works on SQL DWH
The Data Cleansing script for MDW Tables on Analytics SQL Pool has been adjusted to apply custom transformation before applying supernatural keys. Before this, the script would result in an empty insertion.
9596: Custom Semantic Measure dialog can now be resized and maximized
The dialog could not be resized and did not have a maximize option
8778: Improved messages at empty ODX Data Source Sync
Reformulating the system messages when setting up data sources and synchronization to help users take proper action when synchronization returns with empty results. It now includes a hint that filters on the data source could be too restrictive.
9033: Added an option to reduce memory consumption when transferring data from parquet files to SQL MDW through the ODX server
Limit memory consumption by subdividing parquet extraction into multiple column groups.
9291: The ODX can now handle a lot of execution logs without becoming unresponsive
Dialog updated in wrong thread to inform the user of excessive log messages available.
9372: More robust error handling to fix issue with unsuccessful transfers from ODX to DW
Building ODX failure handling more robust in case a data source transfer completed unsuccessfully, leaving the file Model.json in an invalid or missing state. The new routine will try to reestablish the old file or seeking out the last working version of the data source before the failed transfer.
9556: Improved incremental load on ODX to work with string data type
ODX generated extraction script now applies the right MAX criteria to the query when extracting an incremental load based on a string data type. This would generate empty extractions previously.
9561: ADF Date datatype and Synapse transfer error
ODX now identifies Date types as a native parquet data format and generates the proper table format for Polybase transfer in Analytics SQL Pool MDW.
9580: ODX can now creating a parquet file larger than 2GB
The variable containing the file position of the parquet file when we upload the data is an integer, but should be of type long. This meant that a file larger than 2147483647 bytes would overflow to a negative value and the upload will fail.
8537: Improve display of very large custom transformations etc.
Very large custom transformation is now handled in the user interface to ensure a fast and stable workflow. This is done by limiting the quick tooltips.
9442: Faster repository loading through the dialog for administration of repositories
The script for fetching the repositories and matching versions have been optimized to allow for faster retrieval and the general timeout setting for the repository has been added to this command execution too. This will allow even larger version history to be easy to load and maintain in the dialog.
9456: Optimizing the appearance of the dialogue Get Stared
With certain display setting the dialog would appear exceptionally large. This is optimized to ensure at more proportional displaying.
9603: Fully qualified names in Custom measure script in Shared Semantic Access Layer
In some instances the fully qualified names was not displayed in the custom measure scripts even though it was set to do so. This has been improved to handle these instances and insure the proper code is generated for the endpoint.
9654: Improving data cleansing script generation for custom transformations
The situation with similar column names in lookup tables could generate invalid transformations scripts for databases running in Synapse Analytic SQL Pool. Proper aliasing is now applied to the script to allow for this situations to be handled safely too.
9658: Any source OLE DB and Any source ADO - improved adding and editing filters
In some cases adding and editing filter models on this data source would not save the changes. This is now improved to safely capture all your changes.
9659: Removed a programming glitch from Resume Execution feature
Updating the UI produced an error that effectively make resume execution impossible to perform.
9691: Drag and drop fields now supported for Data Export tables
You can now drag and drop fields in the selection rules dialog
9695 Adjusting dialog input to actual field sizes
Input validation have been adjusted to ensure proper data length and eliminate issues due to overflowing in some extreme case.
9708: DB/2 data sources (IBM Managed) would produce error when trying to connect.
This have been changed to avoid unnecessary connection attempts that would result in errors.
9725: Updating a project variable refreshes displayed custom transformation automatically
When a custom transformation on a table field uses a project variable a value change in this variable is now instantly displayed in the user interface for this custom transformation.
9726: Allow long running cleanups of old metadata extractions
On large data sources with the application now allows the clean up process to be performed without timing out and producing an unspecified error.
8504 Added extra info on dialog for Scheduled Tasks
The name of the data source have been added to help the user identify the individual tasks in the dialog. This have become even more relevant now that the requirement of uniqueness for task names have been lifted.
9663 ODX supports passthrough of data type Real
Using ADF to populate the data lake now supports the data type Real natively in Parquet files. This makes it possible to move this data type directly in to Synapse Analytics SQL Pool via Polybase for high throughput cases.
9816 Support translations for NAV adapter using BC365 connector
This new functionality will provide translations in a user defined language for table names, field names and option values
7265: New UX behavior when setting hash distribution column for DW in Synapse SQL pool (SQL DW)
The logic for automatically setting a column for HASH distribution will skip DW_ID as default because identify columns are not allowed for HASH distribution.
8262: SQL script editors now also recognize min() function
For code markup the min() function will now show up in the proper color in the code editor.
8449: New icon for tables running in simple mode
The icon is now aligns with the current UI styling
9884: Stabilized ODX to DW transfer
When TX moves data from a ODX Data Lake to the MDW using ODX for the transfer, having a selection rule on incremental data, and update/delete, then the the operation could fail due to an attempt to delete a temporary table twice.
9600: Issue with differential deployment for simple mode tables with . in name on data warehouse
The differential deployment was fixed for tables with . in the name.
9815: CData data source - Setting up incremental load fails with "There is already an object named '<table name>_I' in the database"
This happens when editing an additional CData data source and subsequently deploying a increment load table from the data source.
9902: Oracle data source returns double character length for character columns using Units: Char
The change reserves less space in SQL Server database and saving the user from adding data type overrides.
9927: Qlik Sense Desktop is not working
This was caused by outdated Qlik SDK- The Qlik SDK was updated.
9968: Custom Hash fields are included in the Clustered index when set to primary key
The custom hash fields are no longer included in the clustered index. This will speed up insert and updates on tables with custom hash fields set to primary key.
9981: Custom transformation view on a table keeps re-deploying with differential deployment
The logic was fixed for detecting changes for deploying data cleansing with customizations enabled.
3119/9985: Business Central Adapter - support tables and fields with same translations
Duplicate naming issue is now handled for Business Central adapter.
9986: Incorrect display of execution setup type
When displaying the execution setup type the result could be incorrect and displaying both full loaded and guarded.
9758: Missing severity type in ODX Service Log dialog
Added the severity type "System Service Info" to the filter option
9989: Test connection on add ODX Azure Data Factory source not working
Added test connection logic to ODX Azure Data Factory source setup.
9759: Resolve issue with SMO 2019 having dependency to SMO 2016
Updated the system DLLs and object changes to support SMO 2019 without references to the older version. This will simplify installation for a 2019 SQL environment.
9916: UI: Wrong icon for inactive dimension level on parent-child-dimension
9306: Support source databases where tables do not have a schema
Cleaned up user interface to ensure that data sources with out schemas is handled too.
9555: Issue with synchronizing ODX task state after ODX shutdown
During startup the ODX server will now update any tasks left in a previous running state after an unscheduled shutdown.
9904: ODX ADLS to DW transfer fails when transferring more than one file with limit memory
Using the new feature for partitioned parquet file extraction could lead to errors if more that one file engaged the limited memory features at the same time.
10213: Retry execution package in ODX
It is now possible to activate retry on ODX tasks. There are 2 events that can trigger the retry: Task failed and Task finished with errors. The user can configures between 1 and 5 retries and a delay between 1 and 60 minutes. A delayed retry is canceled if ordinary scheduling of the task will start earlier than the retry.
10309: ODX Alert mail server tries to authenticate empty user
The application will now use the proper format for situations without any user/password authentication. E.g. Situations on internal SMTP servers.
10124: Editing a concatenated table in Qlik fails with a null reference error
It is now again possible to edit a concatenated table in Qlik.
10257: Better handling of database objects with extended properties from other sources
When deploying we examine the extended properties of database object which could result in errors if they didn't conform to the TimeXtender data types. Now we will ignore extended properties that are not directly managed by TimeXtender.
10288: Fixed the cases where the execution overview sometimes would double entries.
This was only a display problem that had no impact on actual execution.
10296: Validation for DW_Id field mapping when mapped from another data warehouse
We have improved the validation of DW_Id field mapping that is imported from another data warehouse to avoid getting the exception: Column 'DW_Id' does not allow DBNull.Value.
10311: Selecting SIFT tables on Business Central Adapters are now possible again
After implementing the BC adaptor logic the ability to add SIFT tables was lost. This is now fixed.
10435: Failing to load parameters for custom selection rules on table mappings.
Custom selection rules were unable to map the parameters to datafields. This is now corrected
10295: Improved handling varbinary field for Incremental loading on Custom SQL Data Source
We have added an improved datatype conversion for varbinary fields on the above data source allowing the ODX to handle much bigger integer values than previously.
10432: Speeding up preview of data using data lake.
In the internal data handling has been optimized to speed up the transfer from ODX to Desktop Application when the user request a preview of the data contents in the ODX data lake.
10500: We have added the TABLOCK hint to the insert operation for batch data cleansing
When inserting data into the valid table we suggest to the server that it should take out a TABLOCK.
10576: SQL Database Cleanup Tool now recognize security tables for SSL tabular endpoint
The SQL Database Cleanup Tool would wrongly suggest to drop the security tables for SSL tabular endpoint. They are now recognized as belonging to the project.
10583: Unable to delete business unit lookup field
If a lookup field is used in a selection rule on another table, deletion of the lookup field fails and throws an error.
10619: OLAP Roles can now have different MDX statements
When setting up Olap Roles with the use of MDX expressions it was not possible to use different expressions. It is now.
10678: Some tables are excluded from the Business Central SQL provider
When a none account dependant table contains a $ sign in its name it would be excluded if it did not start with the account template name. This has now been fixed
The ODX had some structural updates.
2994: Show uneven mappings under tables
Show Uneven mappings can be enabled or disabled in the menu View -> Uneven mappings. When enabled the number of mappings will be displayed on the table and its fields if the table is unevenly mapped.
10684: Business Central Adapter - BC 365 provider support for OAuth authentication
The provider now has support for OAuth authentication
10735: External SQL Connection data transfer cannot transfer TX System fields
When pointing an External SQL connection to a data warehouse database and selecting to transfer data, the mapping of TX system fields would fail because of wrong naming. This has been fixed so the mapping works again.
10743: Error Deploying Permissions based on Schema on Synapse
Setting up security on a schema in Synapse would result in an error when trying to deploy the security. This was due to an incorrect syntax when trying to apply the security to the schema."
10761: Circular reference issue in ODX OleDb Engine
Specific method calls on an OleDb data source would trigger a circular reference, that would eventually cause the program to crash. This circular reference has been fixed.
10763: Issue with synchronizing ODX data source name overwrites the unique short name
In specific cases, the ODX data source name would overwrite the unique short name on synchronization. This has been fixed so it's not possible anymore.
10770: Scheduler can start the same execution package 2 times with a 2 minute delay
In very rare cases where the connection to a repository database in the cloud was unable to be established, the scheduler could start the same execution package 2 times within 2 minutes. This have been fixed, so it's no longer possible.
10788: Error synchronizing AX Adapter Enums
Fixed an issue where the synchronization would remove all enum tables
10918: Conditions are ignored on Semantic Selection rules
Conditions on selection rules in a semantic layer were being ignored. This has been fixed, so conditions are now taking into consideration in the selection rule.
10954: Deploy using an External SQL connection throws "Object reference not set to an instance of an object"
A recently added validation check for field mapping count caused an object null reference when trying to deploy a table from an External SQL connection
10782: Deadlock on executions from ODX
Fixed potential deadlock issue when using an ODX SQL Storage and using the same database as the data warehouse database in the MDW.
10907: ODX - Support for tables containing single quote in schema or/and name for SQL Storage
Applied correct escaping of single quote when extracting information about the table in the SQL Storage
11029: Deleted semantic fields don't remove all related semantic perspective items
Fixed an issue where deleting a semantic field that is used in a perspective did not get remove from the perspective
11034: Errors when using dynamic variables in Azure SQL DB
Using dynamic variables when using an Azure SQL DB could sometimes cause execution to fail
11065: ScintillaNET issue loading SciLexer.dll from Temp directory
Fixed an issue where ScintillaNET could not load SciLexer.dll from the user temp directory
11092: Missing encryption in global database repository table
Fixed that some properties were not encrypted in the repository table dbo.GlobalDatabases
11068: Issue with ODX Column Filter dialog
Fixed issue where ODX Column Filter UI was not updating the list of rules
11074: ADF Concurrency -> ForEach BatchCount parameter
Fixed issue where ODX Azure Data Factory concurrency setting was mapped incorrectly
Jet Analytics 2020 (20.10.1)
March 27, 2021
New and Improved Features
Data Lake-optimized ODX storage implementation including file format change to Parquet
Automatic incremental load from the ODX into a data warehouse
Alerts and e-mail notifications on critical errors in the ODX service
New ODX tab where you can browse the data storage, see information on storage on the table level and select tables for the data warehouse
Data source explorer with functionality for confirming that selection rules, incremental load rules etc. work as expected
Independent synchronize and transfer tasks to make task schedules more transparent
Project lock to prevent multiple ODX servers from using the same ODX project
Safe shutdown of ODX server to make upgrading easier
Improved logging UI and less logging of redundant information
Ability to connect to initializing ODX server from the Jet Analytics application
Fixed
7021: Unable to remove pending tasks in ODX Execution Queue
7821: SQL Server Logins results in error on Azure SQL DB
8403: SSL: Format string defaulting to Invariant Language
8575: Project variables object null reference when edited without opening the script editor
8606: Business Central adapter: Username and password cannot be changed
8765: Cannot deploy primary key delete SSIS package when the data source is bit specific
8767: 32/64 bit execution engine stalls on deployment and execution when failing on initializing communication.
8811: Data Source Excel leaves out columns with type LongVarWChar - text column with more than 255 characters
8863: Error generating Super Natural Key on SQL Data Warehouse
8889: Oracle slow synchronization - affects all bit specific data sources
8892: Timextender memory leak - an issue on data source explorer
8925: SQL Data Warehouse has slow performance with identity insert, when using insert into a table - Data Cleansing
7884: "Cloud Repository is corrupt" is reported if the ODX is unable to reach the cloud repository
8850: "Specified cast is not valid" exception is thrown when backlog was successfully created but the firewall blocked the request to add a project
8907: Azure Data Factory transfer to Data Lake can give an error: "Token has expired"
8911: Incremental load on decimal datatype is not working
8980: Qlik Sense terminate execution issue
8551: Oracle fails when using date fields as incremental load in ODX on OLE DB version
8907: ADF to ADLG2 token expiry issue
8959: Parquet and datetime2 issue
9017: Execution package with retries can return "Broken pipe" error
9039: Issue with execution package with retries
9033: ODX Parquet transfer can use all memory on large transfers
9118: ODX upgrade issue
9115: Table transfer from ODX to DWH fails when ODX table contains a DWH system field name
8659: Error when opening the errors menu when a table contains Geography data
8719: ODX tab closes on F5 (refresh)
9238: Having a Tag on a field mapped to ODX and ODX synchronizes will cause an error
9259: Issue with setting process affinity for more than 16 cores
8266: ODX Config allows you to enter project names of invalid length
9274: Azure access tokens are sometimes not refreshed and expire after an hour causing transfers to fail
9289: Database cleanup recognizes Semantic Security Table after schema change
9287: Azure access token timeout when transferring from Lake to DWH
9337: ADF SQL source incremental load value loses precision for datetime2 where precision is above 3
9344: Incremental load loses precision for datetime data type when the source is an ADF type
Numerous issues with windows and UI elements, that did not scale correctly with display scaling set to more than 100%, has been fixed. The application should now be fully DPI aware and usable on modern systems that default to a higher display scaling factor.
9228: Increase TIMEXTENDERTABLESCHEMA.FIELDHELPTXT to nvarchar(4000)
9428: NAV BC365 wrong conversion of DATE data type
9453: Nav query table - data type varbinary becomes unknown data type
9481: TimeXtender crash if you rename an execution package to an existing name
8969: ODX SAP DeltaQ delta load
9291: ODX get unresponsive when having a lot of execution logs
9457: ODX - temp folder is used for generating file names and will eventually get filled up
9001: Application secret is now obscured in the Global Database settings of the DWH
Application secret in the user dialog for Global Database setting for DWH was in clear text
9538: SQL DWH - Conditional lookup is now correctly cast to the destination data type
The Data Cleansing script for MDW Tables on Analytics SQL Pool was missing an explicit data type cast on conditional lookup fields when the Lookup Aggregate option was set to None. This is important due to the use of CTAS pattern and table switching employed on this specific platform.
9550: Updated logic to support table inserts from views on Analytics SQL Pool
When inserting data into a table from a view the databases on the Analytics SQL Pool platform do not support default values. Therefore the script has been adjusted to include getutcdate() as the value for [DW_TimeStamp] if such a column does not exist in the view.
9539: SQL DWH - Grouped None aggregated conditional lookups would look up the first lookup field for all lookups
The Data Cleansing script for MDW Tables on Analytics SQL Pool with multiple lookup files would only lookup the first field when the Lookup Aggregate option was set to None.
9575: Supernatural keys based on transformed values now works on SQL DWH
The Data Cleansing script for MDW Tables on Analytics SQL Pool has been adjusted to apply custom transformation before applying supernatural keys. Before this, the script would result in an empty insertion.
9596: Custom Semantic Measure dialog can now be resized and maximized
The dialog could not be resized and did not have a maximize option
8778: Improved messages at empty ODX Data Source Sync
Reformulating the system messages when setting up data sources and synchronization to help users take proper action when synchronization returns with empty results. It now includes a hint that filters on the data source could be too restrictive.
9033: Added an option to reduce memory consumption when transferring data from parquet files to SQL MDW through the ODX server
Limit memory consumption by subdividing parquet extraction into multiple column groups.
9291: The ODX can now handle a lot of execution logs without becoming unresponsive
Dialog updated in wrong thread to inform the user of excessive log messages available.
9372: More robust error handling to fix issue with unsuccessful transfers from ODX to DW
Building ODX failure handling more robust in case a data source transfer completed unsuccessfully, leaving the file Model.json in an invalid or missing state. The new routine will try to reestablish the old file or seeking out the last working version of the data source before the failed transfer.
9556: Improved incremental load on ODX to work with string data type
ODX generated extraction script now applies the right MAX criteria to the query when extracting an incremental load based on a string data type. This would generate empty extractions previously.
9561: ADF Date datatype and Synapse transfer error
ODX now identifies Date types as a native parquet data format and generates the proper table format for Polybase transfer in Analytics SQL Pool MDW.
9580: ODX can now creating a parquet file larger than 2GB
The variable containing the file position of the parquet file when we upload the data is an integer, but should be of type long. This meant that a file larger than 2147483647 bytes would overflow to a negative value and the upload will fail.
8537: Improve display of very large custom transformations etc.
Very large custom transformation is now handled in the user interface to ensure a fast and stable workflow. This is done by limiting the quick tooltips.
9442: Faster repository loading through the dialog for administration of repositories
The script for fetching the repositories and matching versions have been optimized to allow for faster retrieval and the general timeout setting for the repository has been added to this command execution too. This will allow even larger version history to be easy to load and maintain in the dialog.
9456: Optimizing the appearance of the dialogue Get Stared
With certain display setting the dialog would appear exceptionally large. This is optimized to ensure at more proportional displaying.
9603: Fully qualified names in Custom measure script in Shared Semantic Access Layer
In some instances the fully qualified names was not displayed in the custom measure scripts even though it was set to do so. This has been improved to handle these instances and insure the proper code is generated for the endpoint.
9654: Improving data cleansing script generation for custom transformations
The situation with similar column names in lookup tables could generate invalid transformations scripts for databases running in Synapse Analytic SQL Pool. Proper aliasing is now applied to the script to allow for this situations to be handled safely too.
9658: Any source OLE DB and Any source ADO - improved adding and editing filters
In some cases adding and editing filter models on this data source would not save the changes. This is now improved to safely capture all your changes.
9659: Removed a programming glitch from Resume Execution feature
Updating the UI produced an error that effectively make resume execution impossible to perform.
9691: Drag and drop fields now supported for Data Export tables
You can now drag and drop fields in the selection rules dialog
9695 Adjusting dialog input to actual field sizes
Input validation have been adjusted to ensure proper data length and eliminate issues due to overflowing in some extreme case.
9708: DB/2 data sources (IBM Managed) would produce error when trying to connect.
This have been changed to avoid unnecessary connection attempts that would result in errors.
9725: Updating a project variable refreshes displayed custom transformation automatically
When a custom transformation on a table field uses a project variable a value change in this variable is now instantly displayed in the user interface for this custom transformation.
9726: Allow long running cleanups of old metadata extractions
On large data sources with the application now allows the clean up process to be performed without timing out and producing an unspecified error.
8504 Added extra info on dialog for Scheduled Tasks
The name of the data source have been added to help the user identify the individual tasks in the dialog. This have become even more relevant now that the requirement of uniqueness for task names have been lifted.
9663 ODX supports passthrough of data type Real
Using ADF to populate the data lake now supports the data type Real natively in Parquet files. This makes it possible to move this data type directly in to Synapse Analytics SQL Pool via Polybase for high throughput cases.
9816 Support translations for NAV adapter using BC365 connector
This new functionality will provide translations in a user defined language for table names, field names and option values
7265: New UX behavior when setting hash distribution column for DW in Synapse SQL pool (SQL DW)
The logic for automatically setting a column for HASH distribution will skip DW_ID as default because identify columns are not allowed for HASH distribution.
8262: SQL script editors now also recognize min() function
For code markup the min() function will now show up in the proper color in the code editor.
8449: New icon for tables running in simple mode
The icon is now aligns with the current UI styling
9884: Stabilized ODX to DW transfer
When Jet Analytics moves data from a ODX Data Lake to the MDW using ODX for the transfer, having a selection rule on incremental data, and update/delete, then the the operation could fail due to an attempt to delete a temporary table twice.
Jet Analytics 2020 (20.5.5)
July 2, 2020
New and Improved Features
BC Cloud Connector App Extension
Name change: Discovery Hub => TimeXtender
32-bit data sources in 64-bit Discovery Hub
Ability to Customize Decimal Scale In Numeric Fields
Simplify "Import Settings from Previous Versions"
h Syntax Highlighting and Autocompletion
Allow related records to be inserted from a view
Easy Way to Create Table from View
Improve Drag and Drop Creation of View from View
Improve Map Custom View Fields
Consistent use of DW_Sourcecode in views
Multiple running scheduled packages from the same project
Split Incremental load marker on multiple sources
Enable incremental load with 'Add Incremental Selection Rule'
Ask the user to synchronize after making a change to a data source that requires synchronization
Show cardinality on semantic relations as arrows (e.g. ->)
Allow manual assignment of system fields on table insert
Drag a field from the Data Movement to Table when Source is ODX
Show schema on external business unit tables
Multiple text file Data Source - Add filename
Deprecated Features
Download of 32-bit version of TimeXtender
TimeXtender Client version
Fixed in 20.5.1
2848: Version note canceled Execute still runs
4411: Project load slow due to external executable projects
4564: UI: "Synchronize Data Types" is placed differently in context menus on table and data warehouse
4637: UI: Missing padding in "Set Up Relations" dialog box (req. Infragistics upgrade)
4675: Issue with SSIS and differential deployment
4766: The Automate Incremental load feature on the DWH adds incremental load to tables where this isn't possible
4831: Custom conditions on any field transformation reference fields in the _R table and ignore transformations on these fields
4995: Verify and update the prerequisites page on timextender.com
5286: Issue with retry in an execution package with multiple packages inside
5315: Primary key null check combined with rec.based validation
5327: To improve deployment performance, _RT table hash columns should be nullable
5359: Data linage down to the data source is not possible
5464: "{" and "}" characters in object names fail in Azure SQL
5506: Error when you turn off using a partition on a table.
5559: Window closes when the tab is closed
5768: SSL - Removing a column and the affected in semantical model
5805: Expire date in About dialog is misleading if you have a subscription license
5822: Aggregate table override data type is applied wrong
5891: Data type override should not be available for additional data sources.
6098: Hourglass overlay is displayed when nothing is deploying/executing
6119: Export deployment step issues when creating documentation
table containing decimal fields.
6213: Object reference error after an upgrade, when synchronizing external SQL data source
6227: Custom view fields are not reordered after synchronizing fields
6229: Reordering table fields "is dirty" issue
6248: Execution package messages on manual stop issue
6350: Data Source with additional source and history doesn't do data cleansing when one source fails
6382: Issue with SQL Database Cleanup Tool
6383: UI: 'Max. rows to copy' label is misleading
6423: Change a data source from X type to SAP data source more than once fai
6443: Change data source to Movex/M3 DB2 and Movex/M3 MS Sql Adapter fails
6463: AZDWH Bulk load data conversion error - Polybase to Azure SQL DWH
6494: Issue with missing fields from CData providers
6496: Performance recommendations suggest aggregation None for lookups when the target is SQL Data Warehouse
6607: Error with data conversion from NVarChar(MAX) field
6636: Ampersand & sign bug in the project name
6638: Version counter bug
6801: Issue with creating roles in ODX security
6859: Query table with fields without a name
6864: Polybase with primary key load from fixed value fields
6872: Issue with moving data with polybase and "copy to" when preview data exists
6908: Missing fields for mappings in custom selection rules
6925: Deployment through multi-environment window fails when using Azure Analytics Services and deployment mode is automatic/universal.
7044: Add data source any CTRL+E
7051: Execution fails when mapping dw_sourcecode from business unit to data warehouse
Fixed in 20.5.2
6908: Missing fields for mappings in custom selection rules
7491: Issue with advanced settings in a CData provider
7515: First run keeps showing up
Fixed in 20.5.3
7589: Data warehouse: default values for Data Factory settings when using a global database are incorrect and fail when the global database does not exist.
7576: Wrong cast when using direct read with column default where source field data type is different than the destination field data type
7594: Issue with ODBC connection pool when using NAV Native on Business Central adapter
Fixed in 20.5.5
7600: Issue with field mappings in Semantic measures
7628: Issue with 32/64 bit execution engine which stalls when running the scheduler and multiple threads.
7659: Remote SSIS package execution only works for SQL 2008.
Jet Analytics 2020 (20.1.7)
May 8, 2020
This version of Jet Analytics has been validated and works with Dynamics 365 Business Central Release Wave 1 (BC16).
Fixed in 20.1.7
6883: Dynamic security doesn't work as expected
6891: OAuth settings file path translation error
6902: Tabular thousands separator isn't checking for 0 decimals
7125: Issue with huge OLAP cubes with many dimension relations causing Jet Analytics to crash hard
7126: Fix UI update issue with huge OLAP Cubes
7151: Issue with analysis services on prem 2017
7154: Issue with SQL 2017
7185: Issue with NAV adapter BC wave 2
7187: ImageCache to improve project load
Fixed in 20.1.6
Bug 6545: Aggregation table custom selection shows wrong fields
Bug 6608: SSL Perspective not created for enterprise64 edition
Bug 6618: Tabular relation on custom fields not possible
Bug 6857: Error when applying write-back on cubes for roles where one or more measures is in the Denied Set
Fixed in 20.1.5
BUG 6345: Decimal datatype converted to currency for tabular
BUG 6455: Collapsing node when move then with ALT Up/Down
BUG 6458: Slow rename of field used in an OLAP server
BUG 6460: Cannot create repository in empty database on SQL DB
BUG 6361: Custom fields isn't visible in measures with Tabular endpoints
BUG 6465: Issue with Qlik (deprecated) not cleaning up datafields on delete
Jet Analytics 2019 (19.11.7)
December 23, 2019
- Fixed Dynamic project variables fail when a variable contains quotation characters
- Fixed Deployment of a table makes calls to SMO which requires more user rights
- Fixed Tabular Model not dependent on RLS security table
- Fixed Additional Connection String property dialog can only hold 255 characters
- Fixed issue where JDM wouldn't properly sync with BC Wave 2 data sources.
- Fixed issue where the Advanced Dimension Editor wouldn't correctly work with BC Wave 2 data sources.
Jet Analytics 2019 (19.9.1)
October 2, 2019
- Added support for Azure AD Authentication for SQL Server Connections.
- Issue with supernatural key as PK and source-based incremental load with hard deletes.
- Incorrect automatic index for lookups with TOP and sorting
- Preview of some Dynamics AX tables in data source fails
- Copy repository dialog not in line with current GUI
- Money, Smallmoney and XML fails when using ADO without overwriting datatypes
- First run proxy issues Dynamics NAV - Query table for company with ' (quote) in name gives malformed T-SQL
- Encrypt connection not read when opening project repository settings
- Opening and closing tabs should keep the size of existing tabs
- External business unit will display wrong connection changes during synchronization when using a global database
- SQL Azure Data Export encryption error
- Some settings are not imported when a previous version is selected on first run
Jet Analytics 2019 (19.6.8)
September 4, 2019
- Fixed issue when generating Documentation with Hierarchy Table.
- Fixed issue where wrong Icons were used for Hierarchy table levels.
- Fixed issues with Standard Views.
- Fixed issue where SQL engines ignore some server compatibility settings.
- Fixed first run issue when setting up the repository.
- Fixed issue where Custom Semantic Layer Measures hidden property is not saved.
- Fixed issues for SQL Database Cleanup Tool grouping all independent objects under "Tables".
- Fixed issue where deploying changes takes a lot of time on step "Building Cache”.
- Fixed issue to implement faster opening of tabs.
- Fixed issue with Performance Recommendations: Include orphan Entire Row Hash Key fields.
- Fixed issue when deploying views - index out of range exception.
- Fixed issue when opening an earlier version of a project where NAV and AX adapters are loaded incorrectly.
Jet Analytics 2019 (19.6.5)
August 6, 2019
Redesigned User Interface
The most striking feature of the 19.6 release is no doubt the redesigned user interface. Over the years, we have received a lot of suggestions for improvements, and in this release, we have implemented changes that we hope will address the most important ones.
-
Flexible Tabs
In the new user interface, tabs are no longer static. You can open the objects you want to work with, for instance a data warehouse or a semantic model, in separate tabs side-by-side and drag tables from one tab to the next. Tabs can also be organized in tab groups to give you a better overview of your work.What tabs you have open is saved, so the next time you open a project, you can pick up where you left off.
With flexible tabs, the UI makes much better use of the width of the application window. The “trees” in the various tabs will also be shorter, since you do not have one or more data warehouses and business units in the same tab. -
Solution Explorer
In the new UI, all the top-level objects in your solution are listed in the Solution Explorer, which is always displayed in the left side of the application window. From this list, you can open individual objects in tabs. -
Warnings and Errors in the Reports Menu
In the old UI, the Warnings and Errors tabs were the odd men out among the other tabs. Because of this, they have been promoted to menu items in the new Reports menu. The menu also includes the execution queue log. -
Start Tab and Other Changes
When you open JDM 19.6, a Start tab helps you get started with helpful links to e.g. recent projects. We’ve also added a fresh set of icons, consolidated stored procedures, user defined functions and script actions under a common ‘Script’ node and tweaked the toolbar and status bar to match the other changes
Data Warehouse Layer
-
Show Join for Lookup Fields using the Default Relation
On conditional lookup fields, the individual lookup fields default to using the default relation between the source and destination table as a join if you have not explicitly added a join. In previous versions of the JDM, there was no indication whether the default relation was implicitly used as a join or the lookup field did not have a join at all. To make this behavior more visible – and thus, more useful – the new release includes a “read-only” version of the join icon that is displayed when the default join is used. -
SQL Database Cleanup Tool Improvements
We have added some small improvements to the tool that helps you clean up your project databases. The basic functionality is the same, however. The tool creates a list of tables and scripts in a data warehouse or staging database that are not part of the current project and gives you an option to delete them.
You can now run the tool on the project level to clean up all databases in the project in one go. In addition to that, the list of objects now uses display names and icons to make it easier to read. Lastly, the tool is no longer called a “wizard” since that was rather misleading. -
Keep Lookup and Supernatural Key Field Values Up-to-date
One of the challenges of using incremental load is that the value of a lookup field on an incrementally loaded table does not change if the value being looked up changes. The lookup field value is calculated when the row is loaded so the usual solution to this problem is to schedule regular full loads of the table.
In this release, we have added a new setting on incrementally loaded tables, “Keep lookup values up-to-date”. When this setting is enabled, JDM will do comparisons to see if any values being looked up have changed and will update the lookup fields accordingly.
The new release includes fixes and improvements to the feature that brings it out of beta. Supernatural key fields are now also kept up to date if you enable the feature. At the same time, an issue in the logic that would trigger unnecessary full loads, has been fixed.
Shared Semantic Layer
-
Hide Measures in Semantic Models
Hiding a field or measure in a semantic model can be very useful if you, for instance, has a custom measure referring to an intermediate field or measure that you do not want the end-user to see in the front-end. You have long been able to hide a field on a table and in the new release, we have added the option to hide a measure as well. -
Improved Authentication for Azure Analysis Endpoints
The new release adds new authentication options for SSAS Tabular endpoints. Previously, the user account executing the endpoint would always be used to authenticate with the server. In the new version, we have added two additional options for authentication. You can enter the username and password for the account you want to use or create a service principal in Azure and user that for authentication.
Deprecated Features
-
'Advanced Options' Display Setting
The Advanced Options setting on the View menu has been removed. The option controlled the display of advanced options, but it was enabled as default and there was little reason to disable it. Therefore, we decided that it was superfluous.
Jet Analytics 2019 (19.2.9)
June 10, 2019
- Fixed issue where the Informix date-time format for incremental rule would use the environment date-time format.
- Fixed issue for when Simple mode on data source would not clean up pre and post steps
- Fixed issue where Azure SQL would not work in ODX
- Fixed issue where a Wrong Mail error mail could be sent by the scheduler
- Fixed issue where OLAP translations were not deployed with Discovery Hub Feature
Jet Analytics 2019 (19.2.5)
April 29, 2019
Data Warehouse
-
Performance Recommendations
As we continue to develop the Jet Data Manager, we add new options and features that improve performance.For instance, the 18.10 release included significant performance improvements for conditional lookup fields
In the new release, we have included a feature to help you take advantage of these improvements with only a few clicks. With performance recommendations, you are presented with a list of possible optimizations and a list of the affected objects. You can deselect any optimizations you do not want to apply, but otherwise, you just need to click OK and deploy your project to improve execution times.
While we could just enable the options and features that improve performance automatically, we take a cautious approach to rolling out the new features. New projects will default to using the improved settings, but we will not change settings in existing projects.
-
Improved Performance for Incremental Load and History Tables
One of the major advantages of using the Jet Data Manager is that improved performance is just a deployment away when we optimize the code generated by the platform. This release includes performance tweaks to incremental load and history. Especially for tables with history enabled, the gains are substantial. In our tests, history-enabled tables execute about twice as fast as before - or even faster. However, we cannot guarantee performance improvements on that level in all cases since it very much depends on the complexity of the table. -
Data Lineage for Custom Views
In the new release, you can map the ‘input’ and ‘output’ fields in a custom view to enable tracing all the way from data source to semantic layer. This information is used both in the visualization options in the software as well as in the documentation it generates.In previous versions of the Jet Data Manager, a custom view would create fields ‘out of the blue’, since the Jet Data Manager cannot automatically map fields from data sources to the fields created by a custom view.
Shared Semantic Layer
-
Dynamic Row-Level Security
In the new release of the Jet Data Manager, you can set up row-level security on models in the shared semantic model based on the contents of a data warehouse table. With this feature you can have a single role that grants access to all domain users and then differentiate what the individual user has access to by supplying a table the contains information about the user and data relationship. -
Add Descriptions for use in SSAS Tabular
You can now add descriptions of tables, fields and measures in a semantic model and deploy them to SSAS Tabular endpoints. The descriptions are useful for helping end users understand the data in Power BI. -
Support for Perspectives on SSAS Tabular
Perspectives can improve the user experience of a complex model for the end-user by hiding the tables, fields and measures the user does not need. You can now add perspectives to semantic models and deploy them to SSAS Tabular endpoints.
Deprecated Features
Due to the improvements to incremental load and history logic on tables in the data warehouse, some settings on tables has been deprecated:
-
Enable BK hash key (Table Settings -> Performance tab): Enabling history on the table will create a similar hashed version of the business key, should you need it.
-
Target-based incremental load (Table Settings -> Data Extraction tab): Enabling history on the table will give you the same benefits with identical performance.
-
Use left outer join (Table Settings -> History tab): This option had very limited use for troubleshooting, but with the new logic, there is no longer any use for it.
Jet Analytics 2019 (18.10.9)
January 2, 2019
- Fixed issue where Culture settings on Text files were ignored in global databases
- Fixed issue with cloning varchar Conditional Lookup Fields
- Fixed issue where older versions of CData sources were required to be installed
- Fixed issue where Performance - Security model saved the "none" values to the repository
- Fixed issue where the wrong table name validation was applied when using simple mode
Jet Analytics 2019 (18.10.8)
December 6, 2018
- Jet EULA updated
- Fixed issue where the entire Row Hash Key would be a primary key
- Fixed issue where the eeployment of primary key SSIS package would fail when using the providers Oracle Data Provider for .NET and Microsoft Oracle Data Provider for .NET
- Fixed issue in the AX Adapter where Incremental load with delete would not work with the Account exclude option
- Fixed issues where the template NAV Adapter would not be affected by changes to the enhancement settings on the main adapter
- Fixed issue in the AX adapter where Incremental load with subtracting would not work when the account setup was set to exclude
- Fixed issue with the parsing of default code page in the text file data source
- Fixed issue where the NAV Cleanup wizard would suggest to remove the necessary Option BCV view
Jet Analytics 2019 (18.10.6)
November 12, 2018
- Scheduler now logs errors and warnings to event log, regardless of the configuration setting.
- Fixed issue where the Up-to-Date option for Lookup Values would fail to deploy.
- Fixed synchronization issues with the Excel data source.
- Fixed issue where datasource settings were detecting false changes when changing tabs
- The AX adapter now using the MS SQL provider from AX7
Jet Analytics 2019 (18.10.3)
October 23, 2018
- Fixed issue where Direct Read and Dynamic Variables were not working
- Fixed issue where batch data cleansing was not working properly with Keep lookup values up-to-date
- Fixed issue where semantic layer custom measures were not using correct setup type
- Fixed issue where custom selectionrule in SSL could not handle renaming of parameter field
- Fixed issue where SQL cleanup wizard was removing security table for semantic layer row security
- Fixed issue regarding SSIS, Dynamic Project Variables, and Data Selection Rules on Incremental Tables
Jet Analytics 2019 (18.10.2)
October 5, 2018
- Fixed an issue where the entire Row Hash Key was not disabled
- Fixed an issue where Aggregated fields would not get marked as modified when source fields were renamed
- Fixed an issue where a Super Natural Key field would not be available in an aggregation table
- Fixed an issue with creating new fields after enabling 'Keep lookup values up-to-date'
- Fixed an issue with CData where REST provider would not be available in the add/edit CData provider
- Row level security is allowed on semantic customer fields
- 'Keep lookup values up-to-date' detects changes regardless of case-sensitivity collations
- Selecting database collation can now be done before creating a business unit or data warehouse database
Jet Analytics 2019 (18.10.1)
October 1, 2018
Feature | Description | |
Azure SQL Database Managed Instance |
This release entirely supports Azure SQL Database Managed Instance, that represents fully managed SQL Server Instance hosted in Azure cloud — allowing customers to easily take advantage of new technology when released by Microsoft. In fact, 18.10 supports any of Microsoft SQL Servers, be it Microsoft Azure SQL DB Managed Instance, Single or Elastic Pool and of course the on-prem SQL database. We recommend MI, but if performance and refresh rate are less important, Single or Elastic pool are also an option |
|
Shared Semantic Layer |
Row Level Security |
|
Hierarchies |
In Jet Data Manager 18.10, you can order fields on semantic layer tables in hierarchies. All endpoint types support hierarchies. |
|
Data Formats |
You can now configure data formats and categories on fields which will be applied to SSAS Tabular endpoints and used in front-ends to decide how to display data. For instance, text categorized as “Web URL” can be displayed as a link. |
|
Display Folders |
“Display folders” is a feature of SSAS Tabular which allows you to organize the fields, measures and hierarchies of a semantic table by adding them to folders. This makes the model easier to browse, especially if it has a lot of fields. With display folders, you can (for example) bucket all address information on a customer table in a “Geography” display folder. |
|
Prevent Deployment of an Endpoint in Specific Environments | Jet Analytics v18.10 includes the ability to set an endpoint as inactive in specific environments. This makes it easier to manage endpoints and prevent overriding production endpoints during development. | |
Guarding | Semantic Models can now be guarded for deployment and/or execution. | |
Prioritize Models on Execution |
In version 18.10, Semantic Models can now be prioritized in the execution engine, which gives the user an option to influence the execution order to get certain items finished earlier than others. |
|
Clone Field |
Jet Analytics 18.10 includes new context menu command "Clone field" on all fields, as well as a new dialog for cloning fields (incl. Conditional Lookups, Supernatural Keys, Custom Hash Fields, transformations, standard data fields). Two options appear in the dialog: Cloning structure (incl. transformations) or data (only adding transformations for cloned data). |
|
Consistent Read on Dynamics NAV Adapter |
When you extract data from a data source that is in use, you can end up with inconsistent data where a foreign key in a record points to a record in another table that does not exist. Jet Data Manager 18.10 can use the fact that Dynamics NAV has a timestamp on every table to minimize this problem. If you enable the new consistent read setting, the JDM will only extract records older than the start of the data extraction. This will prevent inconsistencies caused by data added while extraction is running. |
|
Keep Lookup Values Up-to-Date on Incrementally Loaded Tables |
One of the challenges of using incremental load is that the value of a lookup field on an incrementally loaded table does not change if the value being looked up changes. The lookup field value is calculated when the row is loaded so the usual solution to this problem is to schedule regular full loads of the table. When this setting is enabled, the JDM will do comparisons to see if any values being looked up have changed and will update the lookup fields accordingly. |
|
Improved Oracle Data Source |
Version 18.10 contains improvements to the Oracle data source, which makes it easier to set up the connection and makes the connection Oracle-version independent. The data source connector now supports EZConnect which means that you can simply enter the connection information (server, port and service name). |
|
More Information on Tooltips | Tooltips are now on all fields with information on Transformations. Tooltips on lookup fields will now show information from the lookup data field, joins, conditions, etc. and there is an improved tooltip on conditional lookup fields. The tooltips react to all relevant changes to fields and relations, always showing up-to-date information, and are now shown for 30 seconds. | |
Conditional Lookup Performance and Usability Improvements |
New features:
|
|
Performance Improvements:
|
||
Fixes:
|
Jet Enterprise 2017 (17.12.15)
- Fixed an issue where a Selection Rule on a field in a Table Insert would cause an object null reference
- Fixed an issue with connection string properties for Dynamics AX and Dynamics NAV
Jet Enterprise 2017 (17.12.14)
Overview of the Improvements in Jet Enterprise 2017 (17.12.14)Jet Enterprise 2017 (17.12.14) introduced a number of important modifications. Below is an introduction to the changes made in this version of Jet Enterprise. |
- Added deployment target from SQL 2017
- an now deploy to or list project repositories on SQL 2008s
- Table menu in sub tree view window now displays all available menu items
- Supernatural Keys and Custom hash fields work with Custom Data insert order
- Deploying dynamic perspectives no longer include OLAP steps without being selected
- Better deploy validation on partition feature
- Keep Errors and Warnings on adapter table
- Corrected the Execution Error Message from the Execute Queue
- External BU - Synchronized tables with schema changes are now saved
- Synchronize source field - addressed a conditional lookup field join issue
- Addressed an AX Synchronize tables issue
- Transformation - correct the SQL when using reverse sign
- Execution queue now includes the correct default package logging
- Simple table mode deploy works correctly when script all objects is checked in deployment dialog
- Views - addressed a table insert check on dynamic project perspectives issue
- Application no longer crashes when using perspective
- Data source multiple text file works properly when using a global database
- Add DWH/BU dialog correctly displays setting for ssis transfer
- Addressed an unexpected shutdown of JDM when pressing Ctrl+C in errors or warnings tab
- No longer duplicates transformations when data movement is loading
- Addressed a synchronize AX adapter culture issue
- Table settings do not freeze on edit
- Opening multiple environment transfer is faster
- Addressed Import custom data field name issue
- Addressed warning when comparing hash fields and supernatural keys with an incompatible data type length
- Addressed an issue with merging of conditional lookups with custom conditions
- Addressed a problem with conditional lookups using custom fields with transformations containing other conditional lookups
- Better description of how Simple mode table behaves when the data source is set to continue with data.
Address a lock-out problem with proxy settings - Address an ADO.Net error
- TABLOCK is now available on update of Key Store
- Execution package - address an exclude OLAP server with offline processing issue
- Views no longer have dependencies to data cleansing stored procedures
- The "Find" dialog now sorts results
- UI: Tab icons have the correct color depth
- Partition table on SQL version that doesn't support table partitioning no longer results in error during index creation
- Addressed an issue with modified tables for color blind people
- Addressed a issue when sending to the execution queue
- Edit staging database and data warehouse sets the SSIS Server value.
- Addressed a Remote SSIS Package Path Issue
- Addressed an table name issue when synchronizing AX adapter culture
- Execution Package is now cleaned up when deleting Semantic Model Objects
- Drag and drop now includes a default action
- Added transformations on Supernatural key
- Added Case-insensitive supernatural keys and hash fields
- History enabled table with reincarnation of data combined with SHA-2 512 Hashing no longer causes error
- Multiple environment can now connect to versions before 17.12.9
- Clicking in un-synchronized NAV data source no longer causes a crash
- Additional AX adapter - Loading primary keys from parent source
- Go to Source table for views is now working
- TXStringDateConverter handles invalid dates. (SQL 2005, 2008,2012,2014,2016,2017)
- Project environment transfer refreshes the project information for the destination environment.
- Having many versions of a project in remote environment no longer makes the transfer available
Jet Enterprise 2017 (17.12.05)
Overview of the New Features and Improvements in Jet Enterprise 2017 (17.12)Jet Enterprise 2017 (17.12) introduced a number of important new features and improvements. Below is an introduction to the changes made in this version of Jet Enterprise. |
Feature | Description | KB Article |
Support for SQL Server 2017 |
|
|
Data Tagging |
Jet Enterprise v17.12 enables you to tag individual fields. These tags can then be used in project perspectives or in a new type of documentation, data impact - allowing you to better categorize your data and comply with regulations such as the General Data Protection Regulation (GDPR). |
Data Tagging |
Visualization Possibilities with the Relation Diagram |
Jet Enterprise v17.12 includes a new Project Perspectives: The relation diagram. You can view the relation diagram for each table -showing you the tables that have a relation to the table in question. |
Project Documentation in the Jet Data Manager |
Uniquely Identifying Records with Durable Supernatural Keys |
In Jet Enterprise v17.12, we have added the supernatural key as a field you can add to a table - providing a very useful feature for dimensional modeling |
Uniquely Identifying Records with Durable Supernatural Keys |
Reading SQL Server Synonyms |
In SQL Server, synonyms are a simple, but powerful feature. Jet Enterprise v17.12 includes the optional functionality to read synonyms from the data source. |
|
Customizable and Comprehensive Documentation | Jet Enterprise v17.12 includes more options for customization and content for the auto- generated project documentation. | |
Flexible Data Selection in Data Warehouse | In Jet Enterprise v17.12, data selection rules are defined on the source table level - making them more flexible. | Creating a Data Selection Rule |
Push Execution to Queue and Skip the Waiting |
In version 17.12, Jet Enterprise better integrates the execution queue with the regular deploy/execute flow. |
Using the Data Selection Queue |
______________________________________________________________________________________
Jet Enterprise 2017 (17.5)
Overview of the New Features and Improvements in Jet Enterprise 2017 (17.5)Jet Enterprise 2017 (17.5) introduced a number of important new features and improvements. Below is an introduction to the changes made in this version of Jet Enterprise. |
Feature | Description | KB Article |
Redesigned Interface |
The first thing you’ll notice when you open the 17.5 release is a new and improved user interface. With the redesign, the interface is less cluttered and gives more room to what matters: your data |
|
Internet Connection through Proxy Server |
With the wide use of web-based data sources, more of our customers are likely to be using proxy servers. Jet Enterprise 17.5 now supports the use of a Proxy Server for web traffic. |
Support for Internet Traffic through Proxy Server |
Support for SQL Azure |
Jet Enterprise 17.5 introduces support for using Azure SQL Server for your repository, data warehouse, and staging databases |
Using SQL Azure For Repository, Data Warehouse And Staging Databases |
Improved Conditional Lookup Fields |
The performance, behavior and usability of Conditional lookup fields (the feature that allows you to use a field from one table on another) has been substantially improved. |
|
More options for delete handling | In JDM 17.5, you have more options for tracking records which are removed from history-enabled tables. | More Options for Delete Handling |
Type "0" fields now supported | Jet Data Manager 17.5 includes support for type 0 fields - which are ignored by the JDM. | Use Type 0 Fields on History-Enabled Tables |
General Usability Improvements |
In addition to the redesign of the interface, Jet Data Manager 17.5 contains a myriad of smaller improvements to improve the usability. |
See below |
Deprecated Feature Support | Some older features in the Jet Data Manager have lived out their usefulness and continue to exist in the product solely for backwards compatibility. While backwards compatibility is a high priority for us, such features will now included the suffix "(deprecated)" to help you manage your use. |
(see below for details) |
Improvement to the AnySource Adapter | In SSIS packages created by the AnySource Adapter, the TruncationRowDisposition setting is set to RD_IgnoreFailure. This is the same behavior as, for example, the DB2 data source |
|
General Usability Improvements in version 17.5:
In addition to the redesign of the interface the new release contains a myriad of smaller improvements to improve the usability of the Jet Data Manager:
The Automate wizards introduced in Jet Data Manager 17.1 have been tweaked a bit. One-level lists are now proper lists instead of trees which makes multi-selection possible. You will now get a message if the wizard has nothing to show instead of an empty wizard. And lastly the wildcards you can use in the filter are explained in a tip when your mouse is over the filter box.
The Find window has an improved layout and now supports the same wildcards as the filter function in the Automate wizards.
We have streamlined the delete confirmations to give them a consistent look and behavior. On routine confirmations (such as deleting a field or table) the default action is to delete the object. On objects where the impact is bigger (data warehouses, OLAP cubes, etc.) the default action is not to delete the object.
We have improved the warning message you see when you set a timeout setting to 0 on a data source so it is easier to understand. Jet Data Manager shows the warning message since 0 equals infinity in this context which can cause issues if the data source is not responding.
Previous versions of Jet Data Manager would show an unnecessary warning message when you set up Related Records or Table Inserts. Jet Data Manager 17.5 includes a check to make sure the warning message is only shown when appropriate.
You can open multiple instances of Jet Data Manager on the same machine to work on multiple projects simultaneously. All instances use the same settings file, however, if you change the repository in one instance, this will take effect for all open instances. This can have unpredictable consequences, so Jet Data Manager will now show a warning if it detects that the repository has been changed outside that instance.
When you enable the project setting “Use Integration Services (SSIS)”, SSIS folders will now be enabled be default. They will also be enabled as a default on any new environments you create. SSIS folders are very useful since they prevent SSIS packages with identical names from overwriting each other.
Previous versions had a setting for enabling Active Directory (“AD”) integration. When AD integration is enabled it is possible to browse servers on the local AD by clicking the “…” button next to the server name. When creating the new Options window, we found the setting to be superfluous, so in the new release, we have enabled AD integration and removed the setting. Our hope is that more users will find and use the feature this way.
This release deprecates the following features and settings:
- Time tables. They have been replaced by date tables.
- On tables in the data warehouse: Data aggregations. Use an aggregated table instead.
- On staging databases: Data mapping. There are many better ways to do this in newer versions of the Jet Data Manager.
- On field-to-field data movement operations: Split and concatenate. A custom transformation is a better way to this.
- On conditional lookup fields: Force sub select, Use temporary table and SQL mode. The new algorithm introduced in this version does not make use of these settings.
______________________________________________________________________________________
Jet Enterprise 2017 (17.1.10)
Overview of the New Features and Improvements in Jet Enterprise 2017Jet Enterprise 2017 (17.1) introduced a number of important new features and improvements. Below is an introduction to the changes made in this version of Jet Enterprise. |
Feature | Description | KB Article |
JDM Simple Mode | For situations where you simply need to copy data on a one-to-one basis from your data source to your staging database, Simple Mode is optimized for speed. | Jet Data Manager Simple Mode |
Improved Data Selection | In JDM 17.1, selecting all tables from a data source for including in the staging database is now a one-click operation, and a wizard is now available for selecting table and fields from the data source. | Creating a Data Selection Rule |
Data Selection Templates | Data Selection (xml) templates contain information about the selected tables, fields, primary keys, and incremental load settings you use, and allow you to apply these same settings to additional projects | Reuse Data Source Selections |
Incremental Load Wizard | When you have more than a trivial amount of data in a table, incremental load becomes incredibly useful. While setting up incremental load for a single table is fast and easy in previous versions of the JDM, in this release you can set up incremental load for any number of tables in a wizard-style interface. | Configuration of Incremental Loading |
Automated Delete Handling for Incremental Load | If you use incremental load on a data source, and records are deleted, the tables in your data warehouse can become out of sync with the data source. In Jet Data Manager 17.1, automated delete handling is available as an option on incrementally loaded tables. | Configuration of Incremental Loading |
Using 'Raw-Only' fields | "Raw-Only" fields can now be defined in a staging database to allow you to define fields which may be used for calculations or data cleansing (ie: behind the scenes stuff) but wouldn't need to be displayed to the end users for reporting. | Using 'Raw-Only' Fields to Hide Data not Needed for Reporting Purposes |
Overriding Data Types |
The world of data is growing and new data sources appear every day. These sources can vary wildly but when you consolidate them all in one data warehouse, all data needs to have a data type that conforms to the Microsoft SQL Server. The JDM now includes a new Data Type Override feature to handle tasks like these. |
Synchronization of Data Types in the Data Warehouse |
Improved Snippet Management |
All snippets are now managed in one consolidated window, from where, you can add, edit, organize, import, and export all snippets regardless of the type. To further streamline the snippets feature business functions have been renamed OLAP snippets. |
How to use SQL and Business Function (OLAP) Snippets |
Easier Application of Constraint Suggestions |
In the new version of the JDM, you can now get primary and foreign key constraint suggestions for all tables in a staging database or data source and apply them all at one time. This functionality uses the new Automate wizard interface that also powers the new incremental load setup feature. |
Constraint Suggestions In The Jet Data Manager |
Setting Database Schemas at the Data Source Level | In previous versions of Jet Data Manager you could define a database schema at the data warehouse level and the table level. In scenarios where the number of tables is very large, schema usage can very useful for keeping tables organized. Jet Data Manager 17.1 allows you to set a schema at the data source level as well. | Database Schema |
Safer and Faster Hashing Algorithms | In Jet Data Manager 17.1, we have overhauled the hashing algorithm to make it easier to debug hashed fields and to address some limitations in the earlier implementation that could cause problems with very large history-enabled rows. | Hashing Algorithms in the Jet Data Manager |
Setting Data Type Defaults for New Fields | The Add Custom Field dialog now includes an option to set your own default settings for a specific data type - allowing you to add multiple fields with settings that deviate from standard defaults | Set Data Type Defaults for New Fields In The Jet Data Manager |
Remove Highlighting of Object with Descriptions | It is now optional for the JDM to display objects with descriptions in bold face. | Remove Highlighting of Objects with a Description in the Jet Data Manager |
Configuring Security on Tables in the Staging Database. | In previous versions of Jet Data Manager security could only be managed on the data warehouse. Because it can very useful, we have added the security setting to the staging database, as well. | Configuring Staging Database Security |
Jet Data Manager 16.10.4
Minor Fixes / Bug Fixes
- Dynamic Project Variable resolution error
- Query table: CommandTimeout is not updated correctly in SSIS package
- Junk dimension dialog issues
- Remove unused sections from documentation feature and include external SQL Connections
- Project perspectives: Program terminated due to missing check if table is of type view or table
- Possible protected project corruption
- Resolve issue with Remote Environment Deploy Full with Managed Execution
Jet Data Manager 16.10.3
Minor Fixes / Bug Fixes
- Cannot deploy and execute OLAP Server with offline processing when having OLAP roles on the database.
- Conditional lookup can use itself as join when using table relations.
- Custom table insert: Unable to add unless two tables are present.
- Execution package: Wrong cast can be made under certain circumstances.
- Security roles: Unable to deploy role after deleting a fields from a table included in a security role.
- Table insert: Command timeout not set on BulkCopy.
Jet Data Manager 16.10.1
New Features
- The new Differential Deployment is a more efficient way of only deploying the parts of your project that are required.
- The Deployment Status Report is an export file that contains a list of what needs to be deployed.
- The new Managed Deployment helps to manage dependencies for the user.
- Now the Data Export allows you to push the content of a data warehouse to another database.
- The new Dynamic Project Variables is a kind of project variable where the value of the variable is generated by a custom script written by the user.
- New Custom Table Inserts give the user the ability to write their own table inserts.
- Users can now Guard Data Sources which prevents tables that get their data from the data source from being deployed, executed or both.
- You can now show the Data Types on Fields in the project tree.
- You can now create relations between the system fields added by JDM and other system fields or regular fields.
Improved Features
- In order to accommodate the new deployment features the Deploy/execute Workflow has been redesigned.
- New support for SQL and Oracle data sources and the Dynamics NAV and Dynamics AX adapters.
Sources - Users can now limit access to certain functionality to Active Directory (AD) groups using Environment Security.
- Column Permissions is an improvement to the object level security feature by adding a new level of granularity.
- Incremental Cube Load Improvements
- Faster Setup of History Tables
- Easier to Choose Tables for Full Load
- Improved Performance with Batch Data Cleansing allows users to choose to split the INSERT statement up in batches during data cleansing.
- Better Performance when Full Loading Incremental Tables
- Related Tables Included in Dynamic Perspectives
- Execution Package Setup is now Logged
Minor Fixes / Bug Fixes
- Ftp task: JDM crashing when trying to delete a FTP task
- Invalid table settings: Empty tables right after execution
- DateTable: FiscalYear is advanced 1 year ahead of normal year
- JDM Environment Error dialog spelling mistake
- Resume Execution Issues
- Relations added by constraint suggestions is added twice and in wrong location
- Executing an external business unit error message missing
- Remote Security Controller Optimization - Added resolve cache
- Step null reference logging errors
- Impact analysis on field not showing impact with usage in conditions
- UI update error when drag-dropping a transformation from one field to another
- Change to User Rights prompt user several times about save/close
- Cubes incremental loading issue
- Wrong Editable Name for Adapter fields in Business Unit
- Deploy/Execute Completed node color
- Staging DW_Id cannot be mapped to DWH DW_Id from Data Movement Pane
- Differential deployment additional NAV datasources
- Join Condition Treating NVARCHAR as INT
- Excel data field edit dialog looks strange
- External business unit and "postfix valid tables" setting error
- Executing external business unit errors
- OLAP KPIs can have empty names and names already in use
- Checkpoints working incorrectly
- Aggregate Table: Doesn't update datatype if changed due to synchronization
- Tooltips disappear too soon
- Wrong display of time in deploy/execute dialog.
- External business unit with pre/post script managed execution
- Concatenate table support: Qualifying field names
- Concatenate table support: Changing field names
- Missing documentation items
- External step failures do not pass on original error message
- Data source name validation
- JDM makes unnecessary connection to remote environments
OVERVIEW OF NEW FEATURES AND IMPROVEMENTS IN JET ENTERPRISE 2016 UPDATE 1
Jet Enterprise 2016 Update 1 introduced a number of important new features and improvements around data warehouse functionality and the deployment and/or execution performance. Below is a collection of features added in this version of the Jet Enterprise along with links to the relevant KB articles.
Feature | Description | KB Article |
---|---|---|
Differential Deployment |
Differential Deployment adds more automation to the deployment process by deploying parts of your project without deploying everything. | |
Managed Deployment |
Managed Deployment adds more automation to the deployment process by managing dependencies to make sure that objects are deployed in the correct order. | The Deployment and Execution Process |
Deployment Status Report |
Deployment Status Report is an export that contains a list of what needs to be deployed. You can generate the report for projects, data warehouses, business units, and OLAP servers. | The Deployment and Execution Process |
New Deploy and/or Execute Workflow | The deploy and/or execution workflow has been redesigned to accommodate the new deployment features. | The Deployment and Execution Process |
Data Export | Data Export allows the user to push the content of a data warehouse to another database. Supported by SQL Server (including Azure SQL), Oracle, and text files. | |
Dynamic Project Variables |
Project variables allow the user to save information in project-wide variables for use in custom transformations, scripts actions, custom views, customized code and selection rules. Dynamic project variables is a project variable where the value of the variable is generated by a custom script written by the user. |
How to Use Project Variables and Environment Specific Selection Rules |
Custom Table Inserts | The ability to create Custom Table Inserts has more flexibility compared to the Table Inserts feature already available in the product. | |
Guard a Data Source | When guarding a table or data source will NOT be deployed and/or executed when the normal deployment and execution of the project is done. | |
Environment Security | Environment Security allows you to limit access to certain functionality to members of specific Active Directory (AD) groups. The Jet Data Manager will also log events in the environment to the Server Log table in the repository. | |
Improved Data Warehouse Column Permissions | Column permissions allow the user to set permissions on specific columns/fields on a table, not just the entire table. | Data Warehouse Security JDM 2016 and Newer |
Execution Package Improvements | Execution packages now have a managed execution section that will decide the order in which objects are executed based on dependencies. | |
Batch Data Cleansing | The Jet Data Manager has the ability to split an INSERT statement up in batches during data cleansing. This saves log space on the SQL Server which gives you better performance on large tables with millions of rows. | Batch Data Cleansing |
Related Tables Included in Dynamic Perspectives |
The JDM now takes table relations into consideration when calculating what tables will be included in a dynamic perspective. | |
Execution Package Setup is now Logged | The new release contains an addition to the execution log. In addition to the execution diagram and message, you can now view the settings used for the execution. |
Execution Logging and Statistics |
Jet Data Manager 16.2.3
New Features
- Support for SQL Server 2016
- Adding the ability to add Usage Conditions to execution packages for better control over when execution packages run, such as having full load executions only happen in a production environment but not the development environment. ( Creating an Execution Package )
- Custom password protection has been added for SSIS packages that use SQL Server logins ( Custom Password Protection for SSIS Packages )
Improved Features
- Improved selection criteria for AX companies that allows new companies to be automatically included when data is pulled ( Add Dynamics AX Adapters )
- Expanded the functionality and usability of Project Variables allowing developers more flexibility ( How to Use Project Variables and Environment Specific Selection Rules )
- Improved Project Perspectives by allowing the deployment of a perspective in a remote environment as well as being able to execute perspectives that include cubes. ( Setting Up Multiple Environments: Single Server Configuration )
- Improved support for subscription licensing by having the JDM automatically contact the activation service when there is less than 30 days left before the expiration date of a license.
- The performance around the amount of time it takes to open projects has been drastically improved for larger projects with many versions.
- Significant performance improvements when using conditional lookups on large tables.
- The maximum size of NAV Option Field lengths has been increased to 4000 characters.
- Support for additional SQL Server data types such as "time", "datatimeoffset", or "XML".
Minor Fixes / Bug Fixes
- Wrong Data type in Transformation View in fixed transformations
- AutoIndex: PK Index on Raw - Issue with BK_Hashkey enabled
- Better handling of unsupported index types
- IsDirty not set when editing an Aggregate Table’s DataGridValues
- Error adding external business unit containing a mapping table
- External BU: Only possible to drag one table at a time and not the entire tables-node.
- Edit custom data on empty table
- Add/Edit Prioritization with External business unit in the project
- Upgrade project repository with empty backup file location
- Staging Name not changed when renaming External Table connector
- Multiple Environments: Crash with unhandled exception on second transfer in same session
- Markup scripts loads project variables as parameters
- Not possible to use a View in a Table Insert
- Unable to extract System Fields from Source
- Issue with the +1 function on the Add Join dialogue
- Views missing as parameter in stored procedures
- Aggregate DataField edit group-by/aggregation type error
- Deploy table with source based incremental rule with spaces in source name error
- Incremental load on CRM Online fails if blank space in Data Source name
- Issue with Incremental load on DWH when blank space in DWH Name
- Incremental Update of Cubes not working with Distinct Count Measure
- Perspectives: Wrong execution order
- Execution Packages: Full load tables not deleted from list if deleted from the project
- Incr. load on cubes does not update partitions when the fact table has been truncated
- Fixed DateTable name length errors
- Date Table Custom Period Column Name error
- Perspectives: Wrong order and multiple instances of same item
- Condition on a transformation is not loaded correctly on DWH
- DistinctCount measure fact tables is processed full every time on incremental loaded cubes
Jet Data Manager 15.12.4 (Bug fix release)
Resolved Issues
- Fixed issue where users could not open a project when a Custom Condition was being used on a SQL Snippet transformation
- Fixed issue that would throw an "Error loading project tree" error when a fixed join was being used on a text field with an empty value
Jet Data Manager 15.12.3 (Bug fix release)
Resolved Issues
- Fixed issue where scheduled executions would fail in some instances with a "Index Out of Range" error.
- Fixed issue where the AccentGrave and Quote option in ODBC connectors was switched in the code, forcing upgraded projects to fail and preventing new NAV Native connections to be made.
Jet Data Manager 15.12.1 (Bug fix release)
Resolved Issues
- Fixed linked server issue in External SQL connection
- Fixed problem with execution packages that use sub packages
- Resolved problem with Full Load feature in execution package not working with some adapters
- Resolve Binary incremental problem on GP adapter
- Resolved problems with project not able to be deployed to SQL 2005
Jet Data Manager 15.11.3 (Bug fix release)
Resolved Issues
- Fixed problems with custom periods in date table and added Saturday as an option for the start of the week
- Fixed problem with some varchar and text SQL data types on AX and NAV
- Resolve issue with some AnySource view schema options missing
- Fixed issue where Query tables would not apply the schema the first time
- Resolved issue with usage conditions for data selection rules on adapters
- Resolved issue where some junk dimension keys could cause project corruption
Jet Data Manager 15.11.1 (Jet Enterprise 2016)
New Features
- Added functionality to support managing data warehouse security from directly within the Jet Data Manager ( Data Warehouse Security (JDM 2016 and Newer) )
- Implemented execution prioritizations to provide more control over the order in which objects are executed in an execution package ( How to Use Prioritizations in an Execution Package )
- Foreign keys can now be automatically created and maintained in the data warehouse ( How to Create Foreign Keys in the Data Warehouse )
- Implemented an "AnySource" adapter that allows any data source supported by an OLE DB or ADO provider to be used ( How to Use an AnySource Adapter in the Jet Data Manager )
- Added a SQL Database Cleanup Wizard to automate the cleanup of orphaned objects in a database ( How to Use the SQL Database Cleanup Wizard )
- Added the ability to limit the number of concurrent transfers on a data source ( How to Limit Concurrent Transfers on a Data Source )
- Added support for project variables and environment specific data selection rules ( How to Use Project Variables and Environment Specific Selection Rules )
Improved Features
- Improved the functionality of the built-in Date table to support custom periods and a cleaner interface ( Using the Date Table )
- Added support to resume an execution after failure instead of needing to restart it from the beginning ( How to Resume an Execution Package after Failure )
- Improved the usability of aggregate (summary) tables ( How to Use Aggregation (Summary) Tables in Jet Enterprise )
- Added Dynamic Project Perspectives ( Using Project Perspectives in Jet Enterprise )
- Support is included for excluding specific steps in an execution package and setting a full load on incrementally loaded tables within the JDM ( Creating an Execution Package )
- Functionality was added to allow partial deployments in multiple environment configurations ( How to Partially Deploy Objects in a Multiple Environment Configuration )
- Added functionality to allow a specified data source to fail without failing the entire execution package ( How to Allow a Data Source to Fail During Execution )
Overview of New Features and Improvements in Jet Enterprise 2016
Jet Enterprise 2016 introduced a number of important new features and improvements around data warehouse functionality and execution performance. Below is a collection of features added in this version of the Jet Enterprise along with links to the relevant KB articles and videos (when applicable).
Feature | Description | KB Article | Video |
---|---|---|---|
Data Warehouse Security | Provides administrative control of data warehouse security and automatic creation of roles and secured views from directly within the Jet Data Manager. | Data Warehouse Security (JDM 2016 and Newer) | |
Execution Prioritization | Provides execution level control over which objects are processed first, such as copying over all raw data from the data sources before any data cleansing is done to minimize the window of time that the JDM is pulling from a database. | How to Use Prioritizations in an Execution Package | |
Date Table Automation | Enhances the existing functionality for generating dynamic date tables by allowing the user to have better control over date formats, names, and using custom periods such as holidays. | Using the Date Table | |
AnySource Adapters | Extends integrations into any data source that has an ADO or OLE DB data source provider installed on the machine. This supports connecting to a much wider variety of native and third-party data sources such as Facebook, Twitter, Google Analytics, and many other cloud-based platforms. | How to Use an AnySource Adapter in the Jet Data Manager | |
SQL Database Cleanup Wizard | Provides an easy way to clean up the staging database and data warehouse by automatically displaying objects in the database that are no longer used in the project and providing an easy interface for removing them. | How to Use the SQL Database Cleanup Wizard | |
Improved Aggregation Tables | Enhances the way that aggregation (summary) tables work to provide a better user experience in addition to improved performance and flexibility. | How to Use Aggregation (Summary) Tables in Jet Enterprise | |
Dynamic Project Perspectives | Supports the creation of project perspectives that will automatically include all objects needed to execute a particular module. This allows the user to simply select the Sales cube, for example, and have the Jet Data Manager auto-select all dependent objects, therefore making the creation and maintenance of project perspectives much easier. | Using Project Perspectives in Jet Enterprise | |
Full Loading and Excluding Objects from an Execution Package | Execution packages now support fully loading a table that is incrementally loaded as well as excluding specific objects from the execution. This greatly enhances the flexibility provided by execution packages in the project. | Creating an Execution Package | |
Limiting Concurrent Transfers from a Data Source | Provides an easy way to limit the number of concurrent transfers from a data source if the data source only supports a certain number of connections. | How to Limit Concurrent Transfers on a Data Source | No video |
Project Variables and Environment Specific Selection Rules | An interface has been added that allows variables to be used across multiple objects in a project as well as providing a way to support environment-specific data selection rules such as limiting data used in the development environment to only records for the current year to reduce processing time but automatically loading all data once the project is transferred to the production environment. | How to Use Project Variables and Environment Specific Selection Rules | No video |
Physical Foreign Keys | Automatically creates foreign keys in the data warehouse based on relationships that have been defined in the Jet Data Manager. This enables front-end tools such as Jet Essentials and Power BI to automatically detect relationships between tables, therefore making the data modeling process much faster. | How to Create Foreign Keys in the Data Warehouse | No video |
Resuming an Execution Package After Failure | Enhances the execution process by allowing a user to restart the execution package where it left off in the event of a failure occurring during the execution process. | How to Resume an Execution Package after Failure | No video |
Partial Deployment in Multiple Environments | When using multiple environments (such as development and production) the Jet Data Manager now provides users the ability to only move only necessary objects to the production environment rather than having to move the entire project as was necessary in prior versions. | How to Partially Deploy Objects in a Multiple Environment Configuration | No video |
Allow a Data Source to Fail During Execution | Provides users with a way to flag certain data sources as being allowed to fail so that the rest of the execution will continue. This ensures that non-critical data sources (such as an Excel file being moved) will not prevent the entire update process to stop. | How to Allow a Data Source to Fail During Execution | No video |
Jet Data Manager 14.5.13 (Bug fix release)
Resolved Issues
- Fixed issue with NAV Adapter synchronization
- Resolved syntax issue with incremental load on NAV Native with mutiple fields in the selection rule
- Fixed Change Data Source memory exception
- Resolved ODBC DataType System.TimeSpam problem
- Resolved issue with IBM DB2 not able to deploy using SSIS
- Resolved GP Adapter problem with global databases
- Fixed AX synchronization error when no enums present in the AX database
- Resolved FTP Source ExecutionNumber error
- Fixed OLAP security error of "Object not set to an instance of an object" when deploying to the front database using Offline Cube Processing
- Resolved issue with OLAP setup missing in connection manager
- Fixed problem with documentation not working when having external tables on a Business Unit
Jet Data Manager 14.5.9 (Bug fix release)
Resolved Issues
- Issue with duplicated fields on SQL Server data sources
- Issue with selection rules on External Tables
- JDM NAV Adapter (NAV 2013 and newer): Changed max length of Option Values
- JDM NAV Adapter (NAV 2013 and newer): Issue with Option String values when empty
- Salesforce Adapter: Fixed issue with reading very large numbers
Jet Data Manager 14.5.8 (Bug fix release)
Resolved Issues
- Salesforce adapter does not load data into raw table for Picklist and Multiple Picklist tables
- Wrong dialogue shown on "Edit Stored Procedure" and "Edit User Defined Function"
- Application crash when upgrading a SQL Snippet with parameters
- Performance issue when opening execution packages that call other packages
- Problem in T-SQL Query window when a varbinary field contains NULL
Jet Data Manager 14.5.7 (Jet Enterprise 2014 SR2)
New Features
- Added an "adapterless" installation option for NAV 2013 and later that no longer requires the import of objects into NAV ( Using the Adapterless Setup for NAV 2013 and Later with Jet Enterprise )
- Added an Execution Queue to execute objects in the background ( Using the Jet Enterprise Execution Queue )
- Added a Query Tool to query and filter SQL data from directly within the Jet Data Manager ( Using the Jet Enterprise Query Tool )
- Introduced Project Perspectives to make it easier to manage development of individual modules ( Using Jet Enterprise Project Perspectives )
- Added the ability to write customized code into a project to edit the default SSIS packages, views, and stored procedures that are created ( Using Customized Code in the Jet Data Manager )
- Added tools to automate the process of creating junk dimensions in the Jet Data Manager ( Junk Dimension Automation with the Jet Data Manager )
- Added the ability to pull data from an existing data warehouse by an External Tables feature ( Using External Tables in the Jet Data Manager )
- Added support for Clustered Columnstore Indexes to enhance data warehouse query performance ( How to Add a Clustered Columnstore Index in the Jet Data Manager )
- Added Default Execution Packages to enable Managed Execution and multiple threads to be used when manually executing portions of a project ( How to Add a Default Execution Package to a Jet Enterprise Project )
- Added the ability to merge steps in an execution package to facilitate more efficient execution plans ( How to Merge Steps in a Jet Enterprise Execution Package )
- Improved tracing functionality to allow better data lineage and impact analysis of a specific object in the project ( How to Use Data Lineage and Impact Analysis in the Jet Data Manager )
Jet Data Manager 14.2.6
- Resolved issue with table not being marked as dirty if the order of the transformations has changed
- Resolved issue with incremental load using TimeStamp fields on SQL Server data sources
- Resolved issue with upgrade error on tables classified as Large Dimension or Large Fact Table
- Resolved issue with SQL 2005 unsupported Declare statement in Stored Procedures
- Resolved issue with execution order on lookup fields not being calculated
- Resolved issue where order of transformations on multiple environment deployment can be wrong
- Resolved issue with OLAP Front Database Name too short
Jet Data Manager 14.2.5 (Jet Enterprise 2014 SR1)
- Ability for remote execution of SSIS packages ( Remote Execution of SSIS Packages )
- Ability to view logging and statistical information regarding database objects ( Execution Logging and Statistics )
- Support for automatic index creation ( Index Automation )
- Ability to create multiple scheduler services using the Windows Services Management Tool ( How To Add Multiple Schedulers Using the Windows Services Management Tool )
- Ability to add hash key on primary key of table ( How to add a Hashed Primary Key Control Field using Jet Enterprise )
- Support for Columnstore Indexes ( Creating Columnstore Indexes using the Jet Data Manager )
- Support for table and index compression ( Table and Index Compression Control )
- Ability to set security pragmatically using MDX query language ( Configuring OLAP Security )
- Added support for multi-threaded execution ( Creating Execution Packages )
- Ability to define table dependencies for multi-threaded execution ( Defining Table Dependencies )
Jet Data Manager 14.0.3 (Jet Enterprise 2014)
New Features
- Added the NAV Advanced Dimension Editor to allow users to quickly add advanced dimensions to their project ( NAV Advanced Dimension Editor )
- Added a dropdown for measure format strings for quick selection of commonly used formatting ( Measure Format Strings )
- Email notification improvements to allow supply user names and passwords as well as Office 365 integration ( Creating an Execution Package )
- Ability to more easily import custom data from Excel ( How To Add Custom Data (Manually Or Via Excel Import )
- Better synchronization of data types in the data warehouse with the fields in the staging database ( Synchronization of Data Types in the Data Warehouse )
- Support for OLAP Cube perspectives for better control of how data is presented to users ( How to Use Cube Perspectives )
- Ability to create physical perspectives to allow customers that don't own SQL Enterprise Edition to use cube perspectives ( How to Use the Physical Cube Perspectives Feature )
- OLAP security improvements to allow for more robust security considerations including Allow/Deny sets on dimension members and better security handling for multiple environments ( Configuring OLAP Security )
- Ability to prevent the deployment and execution of OLAP objects for better control over the deployment process ( How To Prevent Deployment and Execution of OLAP Objects )
- Addition of display folders for dimension levels for better organization of complex dimensions ( How to Use Display Folders for Dimension Levels )
- Ability to define the default measure on cubes ( Define Default Measure On Cubes )
- Support for drill through actions for better control of what is shown when users drill through data in the cubes ( How to Use Drill Through Actions with OLAP Cubes )
- Support for renaming of the "Unknown" member name ( Renaming the "Unknown" Dimension Member Name )
- Ability to rename measure groups without the need to rename the fact table itself in the data warehouse ( How to Rename Measure Groups )
- Ability to create an exact copy of an existing table structure ( Create a Copy of Table Structure )
- Better support for quickly adding multiple objects at the same time ( Quickly Add Multiple Objects Using the Jet Data Manager )
- Enhanced support for external SSIS packages stored outside of the MSDB database ( How to Use External SSIS Packages Outside Of MSDB )
- Support for using custom aggregations on OLAP cubes ( How to Use Aggregations on OLAP Cubes )
- Ability to control NullProcessing property for measures ( How to Control the NullProcessing Property on Measures )
- Improved support for dimension hierarchy properties ( How to Set Dimension Hierarchy Properties )
- Added a new connector to pull data from Salesforce.com databases ( How to Connect to Salesforce Using Jet Enterprise )
Issues Resolved
- Partition template with Numeric Range Value does not work
- Hierarchy Table Id field data type
- Writeback with Parent Child Dimension
- Problem with Force Unicode on AX Adapter
- Associated measure group is not saved or loaded on Business Function measures
- CRM Adapter connection issues
- Reapply Calculated Measures and Script Commands cannot apply to front database
- DWH Aggregations not correct when based on incrementally loaded staging table(s)
- AX Adapter Additional Adapter problem
- Add DimensionLevel on ParentChild wrong default values
- NAV Adapter with Source Based Incremental load fails on SQL 2012
- Error on Save when removing NAV Native additional adapter
- Deployment of OLAP user rights is slow
- Selecting text in the Description dialog can fail
- German SQL Server and incremental on datetime fields
- AX Adapter cannot synchronize accounts
- Associated measure group is overwritten when definition is updated
- GP adapter can fail on load project
- Bug in IsTombstone code
- Source Based Incremental timestamp cannot subtract
- incremental load does not work on GP adapter using alias
- GP Adapter fails on data load when company field is forced to be nvarchar
- Pre/post script problem
- Bug in Referenced Dimensions
- Bug in Associated Measure group on Calculated Measures
- Resolves some issues when importing project
- Bad message when importing a project as latest version
- Bug: Missing 'Refresh' when building drag-drop dimension with '2 field key'
- Missing refresh when changing the Role name for a dimension
- Problem deleting a full data source
What's New in Jet Enterpris 2014
Jet Enterprise 2014 offers a large number of improvements and new features. The link below contains a document that outlines what these features are and how they are used.
Jet Enterprise 2014 Product Enhancements
This list provides an overview of some of the new features added to Jet Enterprise 2014:
- Added the NAV Advanced Dimension Editor to allow users to quickly add advanced dimensions to their project ( NAV Advanced Dimension Editor )
- Added a dropdown for measure format strings for quick selection of commonly used formatting ( Measure Format Strings )
- Email notification improvements to allow supply user names and passwords as well as Office 365 integration ( Creating an Execution Package )
- Ability to more easily import custom data from Excel How To Add Custom Data (Manually Or Via Excel Import )
- Better synchronization of data types in the data warehouse with the fields in the staging database ( Synchronization of Data Types in the Data Warehouse )
- Support for OLAP Cube perspectives for better control of how data is presented to users ( How to Use Cube Perspectives )
- Ability to create physical perspectives to allow customers that don't own SQL Enterprise Edition to use cube perspectives ( How to Use the Physical Cube Perspectives Feature )
- OLAP security improvements to allow for more robust security considerations including Allow/Deny sets on dimension members and better security handling for multiple environments ( Configuring OLAP Security )
- Ability to prevent the deployment and execution of OLAP objects for better control over the deployment process ( How To Prevent Deployment and Execution of OLAP Objects )
- Addition of display folders for dimension levels for better organization of complex dimensions ( How to Use Display Folders for Dimension Levels )
- Ability to define the default measure on cubes ( Define Default Measure On Cubes )
- Support for drill through actions for better control of what is shown when users drill through data in the cubes ( How to Use Drill Through Actions with OLAP Cubes )
- Support for renaming of the "Unknown" member name ( Renaming the "Unknown" Dimension Member Name )
- Ability to rename measure groups without the need to rename the fact table itself in the data warehouse ( How to Rename Measure Groups )
- Ability to create an exact copy of an existing table structure ( Create a Copy of Table Structure )
- Better support for quickly adding multiple objects at the same time ( Quickly Add Multiple Objects Using the Jet Data Manager )
- Enhanced support for external SSIS packages stored outside of the MSDB database ( How to Use External SSIS Packages Outside Of MSDB )
- Support for using custom aggregations on OLAP cubes ( How to Use Aggregations on OLAP Cubes )
- Ability to control NullProcessing property for measures ( How to Control the NullProcessing Property on Measures )
- Improved support for dimension hierarchy properties ( How to Set Dimension Hierarchy Properties )
- Added a new connector to pull data from Salesforce.com databases ( How to Connect to Salesforce Using Jet Enterprise )
Jet Data Manager 12.9.9
New Features
- Ability to define roles in OLAP security as opposed to individual users ( Configuring OLAP Security )
Issues Resolved
- Fixed issue with HalfYear and QuarterName fields in Date table
- Fixed issue with an error occurring when deleting a field from a view
- Fixed issue with hierarchy table not being marked for deployment when modified
- Fixed issue with Value parameters in calculated measures not being saved
- Fixed issue with display of elapsed time in execution dialog
- Fixed issue with staggered fiscal year not working on German SQL Server
Jet Data Manager 12.7.0
New Features
- Support for System.Timespan when using ADO.NET transfer
- Ability to copy data from fields in the error/warnings tab grid
- Ability to see more details about a cube by right-clicking on the cube in the Cubes tab
- Ability to select the start-from step in an execution package
- Addition of SSIS logging
- Support for text file data sources with Fixed Width and Ragged Right Formats
- Ability for the user to specify the SSIS root folder to be used
Issues Resolved
- Resolved markup script translation for hierarchy levels
- Resolved issue where the dimension browser would fail with a "Provider cannot be found" message
- Resolved issue where the application would crash when setting a Data Aggregation to None
- Resolved issue when deleting an object that is used in a SQL Snippet
- Resolved error when synchronizing an External Business Unit
- Resolved issue when using ADO.NET when there was a field with a money/smallmoney data type
- Resolved issue where Business Function Scripts were not properly deployed
- Resolved issue where OLAP Security would not be properly updated on SQL 2012
- Resolved issue with High Availability Cube Processing in a Development Deployment Toolkit environment
- Resolved issue where NAV Adapter had for NAV 2.60 had problems with non-Western characters
- Resolved issue with Source Based Incremental Load on NAV Adapter when company name has Unicode characters
- Resolved issue where features in trial license do not always get loaded on first activation
- Resolved issue where some tables are unnecessarily marked as dirty
- Resolved issue where a markup script parameter name cannot be renamed
- Resolved issue where multiple "Delete Hierarchy" menu items appear in the hierarchy menu
- Resolved issue where the Multiple Environment window would close unexpectedly if the user tried to create a database that already exists
- Resolved issue where command timeout on SQL object creation is always 30 seconds
- Resolved issue where enabling writeback on cube will fail on deployment
- Resolved issue where DW_ID is not set to the primary key on tables
- Resolved issue where there would be an error loading a project when using Dimension Level as a parameter in a calculated measure
- Resolved issue where Single Table Usage is ignored when using source based incremental loading on the NAV Adapter
- Resolved issue where project could not be opened with message "Error loading Markup Scripts"
- Resolved issue where cube browser was not using front database when High Availability Cube Processing was enabled
- Resolved issue where Edit Custom Field was missing in a Time Table
Comments