Jedox 2020.2 Release Notes 2020.2
This document gives an overview of the new features, enhancements, and fixes in Jedox.
Some Jedox features are released
Jedox features with the heading
Contents
- General
- Jedox Web
- Excel Add-in
- In-Memory DB (OLAP)
- Integrator
- Setup & Configuration
- Technical Health
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 dropdown 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. (need screenshot)
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 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 file corruption, 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. See Integrator interface and port now exposed in Macro engine . (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 cannot 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 fields in the two related sources directly, rather than having to use an additional TableView transform. (44858)
New connection type: GoogleToken
The GoogleToken connection enables the retrieval of 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 |
Updated May 5, 2025