What’s New in Jedox 2018.2


This document gives an overview of the new features, enhancements, and fixes in Jedox Release 2018.2 and in 2018.1.

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 in the final version.

Jedox Release 2018.2


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.

Jedox In-Memory DB

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.

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.

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.

Information about unprocessed journal files in log

If a database contains journal files that are not in the expected enumeration sequence, these files will not be processed when the server starts. In this case, it will now print an explicit message into the log file and rename the unprocessed file in the database directory.

GPU Accelerator ships with CUDA 9.1 runtime

The Jedox GPU Accelerator is now based on CUDA 9.1, utilizing up-to-date CUDA compilers and runtimes. Please note that this change requires the use of a Nvidia graphics driver with version 390 or higher.

Jedox Web General

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.

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.

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.

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.

Jedox Web Spreadsheets

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.

Automatic switch of text metrics engine

Jedox Spreadsheet Server’s text metric engine, which determines the required row height and column width based on the spreadsheet content, will now automatically be adjusted to the browser being used, as the accuracy of a machine depends on the browser.
It is still possible to force a persistent text metric engine in the configuration of the Spreadsheet Server.

Function Wizard shows evaluated function arguments

The Function Wizard in Jedox Web spreadsheets now shows the evaluated value of arguments used in the function:

Jedox Integrator

New dialog layout and icons

The layout of the dialogs and new icons in Integrator Manager has been redesigned for better screen use:

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.

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.

Drillthrough rows have been changed from unlimited to 50,000

In the SVS sample scripts sep.inc.drill_through.php and sep.inc.drill_through_etl.php, which uses Jedox Integrator, the maximum number of rows has been changed from unlimited in older Jedox versions to 50,000. In the named sample scripts, the entry $line = 50000 can be adjusted to your needs. The value for unlimited rows is 0.

SOAP connection: new option for SOAP body

There is a new option “Wrap SOAP body with operation” to support further specific SOAP-based web services.

Basic sets in SAPERPHierarchy extract

Basic sets as defined in the SAP component Special Purpose Ledgers (FI-SL) can now be retrieved with the extract type SAPERPHierarchy.

Security of script jobs and functions

It is now possible to execute all Groovy functions and jobs inside of a Groovy Sandbox. This allows the definition of allowed and forbidden Java/Groovy classes and packages. Moreover, you can now entirely deactivate unused Integrator component types, like JavaScript or R.

Jedox Excel Add-in

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.

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.


Windows Setup

Automatic Java installation has been removed

The Jedox Windows Setup 2018.2 does not automatically install the needed Java Runtime Version 8.
If this software is not found, you will receive the following message, prompting you to download the software from the Java website:
If a higher version of Java Runtime Environment is found, then make sure that the Jedox installation uses Java Runtime Version 8.

New software requirement: Visual C++ 2017 Redistributable

Jedox Windows Version 2018.2 requires additional software, Visual C++ 2017 Redistributable. If Visual C++ 2017 Redistributable is not installed on the target computer, the Jedox Windows Setup 2018.2 will install it automatically.

Jedox Release 2018.1


Release naming

Beginning with this release, Jedox is introducing new release naming policy. Public release names will now be in the format <YEAR>.<NUMBER>. The current release is thus named 2018.1.

Internal version numbers in the form <MAJOR>.<MINOR>.<PATCH>.<BUILD>, e.g. will be kept where applicable, as shown in the screenshot below:

Release pace

Beginning with this release, Jedox is aiming at delivering 4 releases per year.

Jedox In-Memory DB

Jedox Views can be stored on the OLAP Server

It is now possible to store Jedox Views on the server as a global view (accessible for all users) or as a private view (accessible only for the current user). Thus, a Jedox view definition can be stored centrally, and the Jedox View will then be available simultaneously on all frontends (Excel Add-in, Jedox Web, Jedox Mobile) that have access to the server.

Improved effective rights calculation and caching

As of 2018.1, calculation and caching of effective rights has been rewritten to better address complex scenarios where effective rights calculation would take a long time, such as environments with many users (hundreds+), groups, and detailed rights settings.


Jedox Web General

ATTN: Private tasks can’t be created in Scheduler anymore

As of 2018.1, private tasks are no longer supported. It is not possible to create new private tasks or change existing tasks to private.


Jedox Web Spreadsheets

Autocomplete option in Macro Editor is turned off by default

As of 2018.1, the autocomplete option in Macro Editor is turned off by default. In previous Jedox versions, it was turned on by default and, for example, automatically added closing brackets when starting brackets were entered.

This option can be switched on and off with a new button in the toolbar of the Macro Editor, as shown below:

Jedox Integrator

Cube Load with persisted Drillthrough

In the relational database used for the persistence of the drillthrough data, the schema and table may now have names that are not in upper case.

The same goes for the table columns; the column names must match dimension names only in a case-insensitive way.


New Jedox Setup languages

The Jedox Setup 2018.1 supports Estonian and Serbian as new languages.