What’s New in Jet Reports?
Jet Reports 2019 R2 includes several new and improved features. Below is an introduction to the changes made in this version of Jet Reports. These build on the enhancements made earlier this year.
|MS Word Integration||Jet is excited to include integration with Microsoft Word in Jet 2019R2. This new feature will give you a faster and easier way to generate Microsoft Word documents using Jet data. A great time-saver for producing executive reports, financial statements, cover sheets, invoices, and billing statements. No more cutting and pasting errors!|
|Jet Hub Redesign||Jet 2019R2 includes several requested improvements to the user interface of Jet Hub, which incorporate an intuitive design and improved navigation to make managing reports and folders more efficient.|
|Office 365 Authentication||Jet 2019R2 provides the ability to sign in to Jet Hub, as well as the Excel add-in, using Office 365 (or Azure Active Directory) account credentials.|
|Jet Browser Update||Continuing with efforts to bring all the Jet add-in features in line with a consistent look as well as providing intuitive and easy to use interactions, the interface for the Jet Browser tool has been updated.|
|User Administration in Jet Hub||In our effort to reduce the number of applications required to use and support Jet Reports, Jet 2019R2 adds the ability to create and manage users and groups directly in Jet Hub.|
|Business Central (on-premises)||With Jet 2019R2, we continue to extend functionality to increasingly support more features and deployment options for Dynamics 365 Business Central. We’ve now included support for on-premises Business Central installations.|
|Data Source Administration in Jet Hub||In addition to being able to administer user and groups within Jet Hub, Jet 2019R2 includes the ability to create and manage data sources in Jet Hub.|
|Updated Pivot Tables for OLAP Cubes||Jet 2019R2 includes an updated user interface for creating Pivot Tables from OLAP cubes. This includes is a more consistent visual design and better navigation to walk you through creating and inserting your Pivot Table|
|OLAP Cubes in Azure Analysis Services||Another area updated in Jet 2019R2 is added support for OLAP cubes residing in Azure Analysis Services.|
What’s New in Jet Analytics
Jet Analytics 2019 introduces several important new features and improvements. Below is an introduction to the changes made in this version of Jet Analytics.
|Data Warehouse – Performance Recommendations||The 18.10 release included significant performance improvements for conditional lookup fields.
In the new release, Jet has 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.
|Data Warehouse – 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 Warehouse – Data Lineage for Custom Views||In the new release, you can map the ‘input’ and ‘output’ fields in a custom view to enable tracing from data source to the 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.|
|Shared Semantic Layer – 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.|
|Shared Semantic Layer – 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.|
Mark is Senior Account Manager at EBS. His experience lies in the budgeting, business intelligence and reporting space having worked in a variety of roles including, software developer, help desk support, consulting, account management, sales and senior management. Mark has a passion for working direct with customers and working to achieve great outcomes.