Release Notes 2019.3

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

Some Jedox features are released IN PREVIEW. These features have undergone testing and passed quality thresholds, but they should not be used in production until they have reached “generally available” (GA) status.

Jedox features with the heading ATTN include changes, such as deprecations and breaking changes, that may impact settings in your current installation. Always back up your databases and other customized content before upgrading.

General

Object name displayed in delete dialog

The name of the object you want to delete is now displayed in the confirmation dialog in Modeler. (#40462)

In-Memory DB (OLAP)

New rule function PALO.EISANC

This new rule function checks whether a consolidated element contains the specified element in all of its descendants. (#40852)

Rule function NOW() is now DDE-supported for faster calculation

The rule function NOW() is DDE-supported for both CPU and GPU. Be aware that results from NOW() function in rules are volatile by nature, meaning that their result will change on each calculation. As a consequence, the results of rules using NOW() (or dependent rules) cannot be cached. (#41458)

Log messages for file system commit type

Info-level log messages now provide information on the storage types used on the file system. These log messages occur on server startup if cube and/or dimension binary storage is used and when online backup is executed. (#40523)

IN PREVIEW: new shortcut for concatenation

The pipe operator ( | ) can now be used for concatenation in rule functions. For example, instead of CONCATENATE("Value 1", "Value2"), you could use "Value 1" | "Value 2". This shortcut can be used when editing rule definitions in the rule list but is not yet supported in the Rule Editor. (#40853)

ATTN: DDM time dimensions format

When you create a time dimension in Data-Driven Modeling (DDM), the hierarchy is similar to that in the Time Editor. The dimension will also be assigned the dimension type “Time”. Note: the <targetformat> parameter for column headers is no longer available. (#36450)

Improved performance for online backup/download

Database backup and download handling has been optimized, shortening the time needed for commits to the file system and improving performance for large databases. (#40793)

GA: optional timeout for In-Memory DB (OLAP) requests from Spreadsheet Server

A timeout period can be set in palo_config.xml for In-Memory DB (OLAP) requests from Jedox Web Spreadsheet Server. If set, all requests made to the In-Memory DB will abort when the timeout is reached. Value is in milliseconds. Value of 0 means no timeout.

Example setting for a 20-second timeout period: <network_timeout>20000</network_timeout>

This feature was in preview in version 2018.4 and is now generally available. (#37073)

New OLAP database script functions

There are five new OLAP database script functions (#41434):

STR_REPLACE	Replace s a substring of a string with another string
DATABASE_ID	Returns the ID of the database
DIMENSION_ID	Returns the ID of the dimension
CUBE_ID	Returns the ID of the cube
ELEMENT_ID	Returns the ID of the element

GA: lightweight GPU

Lightweight GPU, in preview in Jedox 2019.2, is now generally available. It optimizes memory storage for the GPU Accelerator: calculations on cubes converted to GPU now use the same storage structure as CPU calculations. Converting a cube to GPU is now a much faster process. (#39653)

Version 2019.3 goes even further, introducing a GPU storage cache that minimizes memory transfers between host and GPU. Cube data is cached in a custom, GPU-optimized format, allowing quick access to previously requested data. The memory footprint of a cube on GPU can be significantly smaller than in previous Jedox versions, as only requested data is cached. (#39653)

Jedox Web

IN PREVIEW: Select Elements dialog checks for default subset

When opening the Select Elements dialog from Paste View, the default subset is preselected. If the default subset has been deleted, an error message is displayed when you try to select it in the Select Elements window. (#40250)

ATTN: location of custom database template scripts changed

The location for custom template scripts has changed. Custom template scripts used in previous versions of Jedox must be moved to the new location and require a new configuration key. (#41474)

GA: default Stored Views

You can now flag specific global views of a cube as “default”. When selecting a cube in the Paste View dialog in Jedox Web, the dialog checks whether a default view exists, and selects it if it does. You can flag views as default both in the Modeler and the Paste View dialog itself. (#40918)

Updated May 5, 2025