Release Notes 2020.2

Jedox 2020.2: the best Jedox version ever!

This document gives an overview of the new features, enhancements, and fixes in Jedox, which is currently available at https://www.jedox.com/en/epm-software/free-trial/. 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.

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. 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. Our intention is to get your feedback on these features before making them GA and production-ready. These in-preview features may undergo minor design changes while going through the maturation process. Most in-preview features can be enabled in Jedox Web Administration.

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


General

Changes to version information

In 2020.2, we are introducing several changes with regards to version information of Jedox components. (45196)

Versions will now be composed as follows for all components: major.minor.patch+<additional-information>

Customizable themes for Views

2020.1 saw the introduction of Themes, a set of dynamic formats that could be attached to views. With 2020.2, themes can now be edited and customized with the Themes Editor in the View ribbon, and changes are propagated to all views using that theme. (44650)


Jedox Web

Support for very large dimensions in ComboBoxes now GA

As announced in preview in 2019.3, ComboBoxes support very large dimensions. This feature is now generally available (GA).

When using the option “Large Subset” in the ComboBox Properties dialog, the source data for the ComboBox is fetched on demand as the user expands or searches in the ComboBox list. (41393)

Analyzer option removed from Designer component

As announced in Release Notes 2020.1, Analyzer reports are being deprecated and will no longer be available in the upcoming 2020.3 release. As of 2020.2, Analyzer reports can no longer be created. (44202)

Different data sources for charts

Charts can now have a variety of data sources: Jedox Views, stored views, relational data sources, or (as before) a range of cells; sources can be selected in a drop-down menu. This functionality allows large datasets to be attached to a chart without having to represent it in the spreadsheet itself. (40844)

PALO.VIEW.TABLE() support for Jedox Views

In Jedox 2020.2 charts (see previous entry) also support an additional feature: views that are pasted into a sheet can now be directly referenced by a chart by using the formula PALO.VIEW.TABLE(). Thus, views and data can live alongside each other in the same worksheet. (45134)

Ordering of database objects in Subset Editor

Databases, dimensions, and cubes are now ordered alphabetically in the Subset Editor. (44344)

Ordering of database objects in Paste Data Function dialog

Databases and cubes are now ordered alphabetically in the Paste Data Function dialog. (44345)

Linux: elements order now consistent in Paste View and Modeler

In Paste View dialog, dimension elements are now ordered by root elements, like in Modeler. This behavior is already in place in Windows. (45062)

Reset button in Subset Editor

The Subset Editor now allows you to revert to default settings for all subset filters. The Reset button is located next to the dimension combo box. (40635)

Changes to User, Group, and Roles

New layout of user, group, and role administration. Multiple users, groups, and roles can be selected, and actions can be performed on the selected objects. (44855, 44856)

Direct navigation to components with card titles

Cards were introduced in 2020.1 as a faster way of navigating to various components. Now the component title on the card is clickable and takes you directly to the component. (44613)

Customizable logo and icon for login screen and end-user mode

A custom logo and icon can now be uploaded in Settings Manager. The custom logo replaces the “Jedox” logo on the login screen, while the custom icon replaces the Jedox icon on the login screen and in the top-left corner of end-user mode. Both SVG and PNG images are supported. (44379)

User creation time and last login now visible in Administration component

Since 2019.4, user creation time and last login are stored in the #_USER_USER_PROPERTIES cube. With 2020.2, these values are visible in two new columns in the Administration component. Times are shown in the browser’s time zone and are sortable. (44888)

Currency behavior with different locales

The storage for currency formats in spreadsheet cells has been improved and now preserves the defined currency symbol also when exporting reports as XLSX files. (41392)

Recognition of new time format

The format mm:ss.0 is now recognized as a time format in Jedox and can be formatted as such. (38581)

Admin panels stay open after saving changes

When saving changes to user, role, or group settings, the panel now remains open to allow further changes. (42586)

Gd text metrics engine replaces Freetype

The text metrics engine “Gd” is now used instead of “Freetype”, even if Spreadsheet Server is configured to use Freetype. This change can result in performance enhancements in some scenarios. (39461)

Integrator interface and port now exposed in Macro engine

To enable the use of Integrator variables in SVS scripts, the Integrator interface and port is now exposed in the Macro engine. (44918)

Scheduler UI simplified

The UI for scheduler has been improved to give easier access to scheduler properties. (43701)

IN PREVIEW: navigation history in Integrator

In the Integrator and Modeler panels in Jedox Web, it is now possible to show navigation buttons for the navigation history, and to navigate backwards or forwards to previously used components. Right-clicking the navigation buttons will display the history in a menu. This feature is in preview. (44380)
 


Excel Add-in

ATTN: change in views with no dimensions in rows or columns

In previous versions, pasting a view with no dimensions dragged into rows and columns resulted in a single PALO.DATA cell with a value. In 2020.2, no value appears. (44973)

Jedox Themes now available in Excel Add-in

Jedox Themes were introduced in Jedox Web in 2020.1, and now they are also available in Excel Add-in, enabling a consistent UI experience for all users, regardless of interface. (44677)

ATTN: additional View Themes removed from Excel Add-in

In Jedox 2020.1, the available themes were reduced to Chaplin, Legacy, Lucid, and White. These themes (except White) have now been removed from Jedox Excel Add-in. Excel users now have access to the same themes as Jedox Web users (see previous entry). (44677)

Support for Excel/Office 2010 deprecated

Support for Jedox Excel Add-In in Microsoft Office 2010 is deprecated, as Office 2010 no longer be supported by Microsoft in October 2020. (45219)


In-Memory DB (OLAP)

New API request for all stored views in a cube

The PHP API now has a function palo_server_views to get a list of all stored views for a given cube. (43419)

New function returns database name for given ID

A new function palo_get_database_name gets the database name based on database ID. This functionality is similar that for cubes, dimensions, and elements. (43629)

“Max failed login attempts” now reset after changing password

When a password is reset by the administrator after several failed login attempts, the max-login-attempts threshold is reset, and the waiting time for the user during a login attempt is not slowed down anymore. (44400)

Changes to splash limit in palo.ini settings

The palo.ini setting splash-limit now has an additional, optional parameter that allows you to modify the assumed memory usage of individual cube cell values. This allows you to control the allowed threshold for memory usage of splashing operations more flexibly, while retaining backwards compatibility. (39978)

Journal flush interval option in palo.ini settings

A new palo.ini key journal-flush-interval sets an interval of 1-300 seconds after which journal data will be flushed to the file system. There is also an option to flush every OLAP write operation or to disable journal flushing entirely. Flushing of data prevents possible data loss, such as following a power outage of a server. (45073)

Variables for server/connection details in SVS scripts

Variables can now be used in place of hard-coded connection details in SVS scripts, so that macros accessing Integrator can be written independent of the specific platform configuration. The values for the variable are defined in the configuration file php.ini.  (44943)

Incremental splashing behavior now extended to transfer splashing

In 2020.1, incremental splashing feature was added in Jedox. In 2020.2, it can now be applied in “transfer” splashing by using two new keywords “fullto” and “fullfrom”. Transfer splashing reduces one element by amount x while increasing the value of element y by the same amount. At the same time, it takes the same distribution as x and spreads it to y. Thus, unlike regular transfer splashing, values in the target slice that were previously empty can now get a value. (43593)

SVS upgraded to PHP 7

Supervision Server (SVS) has been upgraded to PHP version 7. Sample scripts shipped by Jedox (e.g. for Drillthrough) do not have to be changed, but modifications to custom scripts (depending on their complexity) may be required. A list of required changes is available in the PHP documentation https://www.php.net/manual/en/migration70.php. (27038)

Log Warning for rules with ISNULL() function

If the deprecated rule function ISNULL() is used, a warning will now be printed to the log file of In-Memory DB server during startup, or when such a rule is created / modified. (44736)


Integrator

TableJoin field selection simplified

You can now choose target fields in the two related sources directly, rather than having to use an additional TableView transform. (44858)

New connection type: GoogleToken

The GoogleToken connection allows to retrieve Google access token using a Google Service Account. This connection type provides an access token for an HTTP service. The result of this connection is JSON and can be consumed directly by a JSON extract. It can also be referenced in REST connections with authentication method “Token” and can be used, for example, to work with Google BigQuery by means of Google BigQuery REST API. (13850)

Additional functions for AI Transform

The AI Transform now offers three additional functions. Interpolation adjusts for missing values in source data. Outlier detection adjusts for any deviation in data that may cause inaccurate results. The Accuracy function calculates several accuracy and error metrics to measure the performance of the forecasts. (44598)

The AI Transform is available to Jedox Cloud users with an AI license.


Setup & Configuration

Wipe command now available for Sandbox

This command deletes the Sandbox directory and JedoxAG folder in local AppData directory, thus removing username, password, and secret. (44449)


Technical Health

Updated components

In Jedox version 2020.2, the following components were updated:

Component

Version

Apache

2.4.43

PHP (Apache)

7.3.18

PHP (SVS/SSS)

7.3.9

Tomcat

9.0.35

OpenJDK

11.0.72020-04-14LTS

Tasks implemented since release 2020.1

The following issues (features, tweaks, and bugs) reported in Jedox 2020.1 have been fixed/implemented in Jedox 2020.2. The development team thanks those customers and partners who have reported issues.

Component

Tickets

OLAP Server

85

SVS

5

Excel Add-in

47

Office Add-in

0

Client Libs

9

Integrator Server

74

Jedox Web

257

Demo content

6

Documentation

72

Setup/CI/CD

100

Jedox Mobile

28

Jedox Cloud

63

Models

151

TOTAL

933