This post is part of the series on Upgrading to Jet 2019.
The new version of Jet Analytics has quite a number of new and improved features.
|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.
|Shared Semantic Layer||
Row Level Security
In Jet Data Manager 18.10, you can order fields on semantic layer tables in hierarchies. All endpoint types support hierarchies.
Ordering fields in hierarchies can be a good way of making a model easier to grasp and use in PowerBI. An example is a table with products that often have multiple levels of categories.
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” 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.
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||
In the next few posts, I’ll be stepping through the upgrade process for Jet Analytics.