See what’s new in the latest Jedox software release

Jedox 2018.2 is available now and we’d love to share some of the key new features and updates with you. At the top of the list is the most wanted feature request from the Jedox Feature Voting Tool and it allows Jedox users to select several frames to be exported as PDFs along with a new dialog, the “Frameset Page Setup” to customize reports. The latest release also offers previews of several new Jedox development initiatives. While not intended for in-production use, these previews give Jedox users early access and an opportunity to test and provide feedback before the feature is generally available.

Below you find the descriptions of key new features and updates in Jedox 2018.2 taken from the release notes. For more details check out the entire release notes document here.

1. General

1.1 Features in Preview

Starting with version 2018.2, some new features will be labeled “IN PREVIEW” in this document. Our intention is to get your feedback on these features before making them generally available and production-ready. These in-preview features may undergo minor design changes while going through the maturation process. Features that are in preview have undergone testing and have passed quality thresholds, but they should not be used in production until they have reached “generally available” (GA) status. For features in preview, we are targeting a maximum of two releases for maturation, i.e., it will take a maximum of two releases until they become GA.

2. Jedox In-Memory DB

2.1 IN PREVIEW: Optimization for database file storage

A configuration option for Jedox In-Memory DB Server allows storage of cube data on the server’s hard drive only in binary format, not in CSV format. The binary format greatly speeds up the time needed for processing files on the file system in comparison to CSV, such as when the server is shut down. This configuration option is now in preview. It can be used by setting the value “no-csv-save” in the palo.ini configuration file.

2.2 New rule template types for subsets

Two new rule template types have been added: global subset element and global subset element (list). These types allow you to build a rule template that will generate instances based on the elements returned by a stored, global subset in a dimension.

2.3 New rule template types for grouping elements by attribute values

Three new rule template types have been added. They enable a set of elements to be retrieved from one dimension and additional sets of elements to be fetched from one or more other dimensions based on an attribute pattern. The returned results of these queries are combined into the overall record set for the template.

More updates in the release notes.

3. Jedox Web General

3.1 Modeler: cube templates create dimension elements

The cube templates in Modeler will now create missing dimensions needed for a given element, including a default set of elements within the dimension.
If the dimensions already exist with the expected name, they will not be re-created, and no elements will be created or modified in them. These dimensions will be used in the created cube.

3.2 Confirmation prompt about unapplied changes in Time Editor

When using the Time Editor to make changes in a dimension of type “Time”, a warning will now appear when the user tries to navigate out of the Time Editor without updating the dimension.

3.3 Tagging enabled for all file types

Setting custom tags is now enabled for all file types in Report Designer, including Framesets and PDF files. Using tags makes it easier to look for corresponding files.

3.4 IN PREVIEW: batch export in PNG format

Besides export of reports in PDF and XLSX format, it’s now also possible to create tasks that will export the report in the PNG image format.

4. Jedox Web Spreadsheets

4.1 PDF export of framesets

In a frameset, several frames can now be selected to be exported as PDFs. The frames to be exported can be selected in the frameset properties by checking them with the “Use for Export” option.

When opening a Frameset in Report Designer, the new dialog “Frameset Page Setup” allows content to be resized by percentage, in which case the content will be exported in the chosen page orientation and format, or by using the “Fit to…” option, which currently only allows the 1×1 setting. When used, the PDF will consist of a single page, showing the original size of the frameset content.

Note that print range settings from individual frames will be ignored if the PDF consists of multiple frames.

More updates in the release notes.

5. Jedox Integrator

5.1 New dialog layout and icons

Layout of the dialogs and new icons in Integrator Manager have been redesigned for better screen use:

5.2 Subset filter with array variables in cube and dimension extract

In dimension, cube and cube slice extracts, filters on global subsets can now contain all kinds of subset variables, like array variables for attribute filters. Previously, only scalar subset variables could be used.

5.3 Hide empty project groups

As of 2018.2, project groups with no content will not be displayed in Integrator. If necessary, use the Settings Menu to toggle the behavior within a session.

More updates in the release notes.

6. Jedox Excel Add-in

6.1 New Connection Assistant

The Connection Assistant in Jedox Excel Add-in has been redesigned. There is now only a single type of Connection. The connection properties consist of settings for both connection to the In-Memory DB Server (such as from the Paste View dialog) and Jedox Web (such as in the Modeler).

Existing connections will be converted to the new Connection Assistant.

6.2 Adding TLS client certificates in the Excel Options dialog

The client certificates required for secure communication with the Jedox In-Memory DB Server can now be edited via the Options dialog in Jedox Excel Add-in.

We are committed to keeping newer versions compatible with previous versions, especially solutions built with previous versions. Any changes in the software that would require a change in a solution built
with the software will be announced during the ramp- up phase before the change goes into effect.

Try the latest Jedox Version

Author: Vladislav Malicevic