Highlights of Jedox version 2019.3

Jedox 2019.3 gives report builders even more freedom to create custom visualizations and charts for high impact reporting and analytics. This new version brings “most wanted” features as suggested by Jedox users, such as “search in combo boxes”, further improved export of web reports to Excel as well as enhanced connectivity for Qlik® BI systems.

Analytics & Reporting: Powerful Visualization and Search in Combo Boxes

Search the ultimate combo box

Jedox combo boxes enable users to select elements from a drop-down list. In new Jedox 2019.3 users can now search as they type within dimensions. A lightning-fast way to find an element compared to navigating along the elements tree. The new Jedox combo boxes also support large dimensions with over a hundred thousand elements (in-preview feature), making them the ultimate tool for building and navigating enterprise-level reports.

Searchable Combo Box

Search as you type in combo boxes

Create new visualizations

Jedox 2019.3 unlocks the full design power of the HighCharts library and gives users access to nearly unlimited options for visualizations and customized charts. Design your chart with a few clicks and simply select properties from the menu. Power users go to the ‘Advanced Properties’ dialog to access all customization options available in the Highcharts standard library.

Screenshot Chart Options

Select from a variety of chart options

Control the data in your chart

Users will be delighted with the new capability that gives them control in arranging a data series from the bottom/left, or the top/right for stacked charts. This new functionality is straight-forward and easy-to-use as it works in the same way as stacked charts in Excel.

Order Stacked Chart

Arrange your data in stacked charts

Export web reports seamlessly to Excel

Jedox users work seamlessly across the web (front-end) and in Excel spreadsheets. Jedox 2019.3 provides an even better export of web reports to Excel. If form elements such as combo boxes or buttons are hidden in your original web report they will also be hidden in your Excel file (.XLSX).

Make it faster to analyze data

In Jedox 2019.3 you can set a Default View for a specific cube for all users. This gives them a head start as the Default View is always pre-selected, making it faster for users to analyze their data. The Default View can be set in the “Paste View” dialog, or in Modeler.

Default View

Select a Default View

Data Modelling: Smart Dimensions for Data-Driven Modeling and Default Subsets

Make modeling easy #1: DDM (Data-Driven-Modelling)

In the future, Jedox users will see increased automation of data modeling. With the Data-driven Modeling (DDM) feature users can build a database in minutes just by importing data from an Excel file. In the new Jedox Version 2019.3 the DDM engine recognizes time dimensions, versions and measure types and automatically creates the correct settings in the time editor.

Make modeling easy #2: Predefined Subsets

Create standard subsets by simply ticking a box when you create a dimension. 2019.3 introduces two predefined subsets: “All” (all elements sorted by name, flat) and “Base” (base level elements only, sorted by name, flat). Naming and definition of predefined subsets can be adjusted and they are available for manually created dimensions (Modeler) as well as for automated dimensions loads in Jedox Integrator.

Data Integration: Enhanced connectivity for Cloud systems, SAP S/4HANA, QLIK® and AIssisted™ Planning

Cloud-based systems (REST)

The Jedox integration for REST connections, a widely used standard for web services and other cloud and on-premises systems, has been upgraded for greater usability with a new connection “OAuthToken” that handles token authentication. You only need to specify the token once and it can then be reused in multiple REST calls, which simplifies your project.

2019.3 also allows more direct and seamless integration with 3rd party systems by introducing the option to use REST in a JSON/XML load. This means that Jedox can load data into any 3rd party REST compliant system directly (with appropriate security). This improves Jedox write-back capabilities, for example, to cloud-based ERP systems.

SAP S/4Hana

Many Jedox customers use their SAP ERP system as a data source to create financial planning, budgeting and forecasting. The latest SAP connector now officially supports the latest versions of SAP S/4HANA up until the latest S/4HANA 1809 release for use in multiple environments.

Qlik®

With Jedox 2019.3, the connectivity to Qlik BI systems has been extended further to allow more flexibility and scalability for large models in integrated Jedox+Qlik solutions.

Dimension type in Jedox Integrator

For new technology such as machine learning and artificial intelligence, the Jedox Integrator acts as the “data hub” for integration, pre-processing and mapping of data from cloud and on-premises sources. You can now already specify in integrator dimension loads the dimension type of the data e.g. time or measure, simplifying the analysis of the data model by web services such as Jedox AIssisted™ Planning.

See the complete Release Notes for Jedox 2019.3 with all new features and updates in the in the Jedox Knowledge Base. The latest Jedox version is available now for testing as a cloud trial from the Jedox website.