Release Notes 2019.4

Jedox 2019.4: the best Jedox version ever!

This document gives an overview of the new features, enhancements, and fixes in Jedox 2019.4, 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

Newly supported platform

Jedox now supports Windows Server 2019.

In-Memory DB (OLAP)

GA: default Stored Subsets

You can now flag specific global subsets as default, both in the Modeler and the Paste Subset dialog itself. (#40919)

New behavior of the Suppress Zero option

In Jedox Web and Excel Add-in, the Suppress Zero option can now be enabled for rows, columns, or both. (#42560, 42561) 

User creation time and last login now stored in System database

There are two new elements in the USER_PROPERTIES dimension that allow administrators to better monitor server activity. CreateTime indicates the time that a user account was created. LastLoginTime stores the time of the last successful login. Both times are stored as unix timestamps and are independent of time zone. (#42861)

Optimized performance for Lookup rules

OLAP Lookup rules with structures such as [‘test’:’target’] = B: ”[‘Month’: ‘#_month'[‘#_month_’:’Previous’], ‘test’:’source’] have been optimized for increased performance. (#39739)

New database script commands for rules

Two new database script commands allow you to delete all the rules in a cube when no rule is specified (RULE_DESTROY) and list all the rules in a cube (CUBE_RULES). (#43024)

Creating new dimensions / new cubes with dimension templates generates predefined subsets

When creating a new dimension or a new cube in the Modeler, two predefined subsets will be created if you select a dimension template. (#42377)

Creating dimensions via Data-Driven Modeling generates predefined subsets

When creating a new dimension in Data-Driven Modeling, two predefined subsets will be created for Version, Day and Measure-type dimensions. (#41906)

Improved error handling for saved Views

Stored Views or Views saved in a spreadsheet fall back to a default setting in any scenario that can cause an error, such as a missing element or a renamed stored subset.

This also has implications for the handling of some errors in subset results. Passing an invalid string as part of a “Picklist” subset (i.e., a string that cannot be mapped to an element, or a string specifying an element to which the current user has no access), the subset will not return an error anymore; instead, it will ignore these strings in the picklist. Furthermore, if an “HFilter” subset specifies such an unknown element string, it will fall back to either the default read element or if none is defined, the first root element (visible to the current user). (#26539)

Enhancement of the year-to-date hierarchies in the Time Editor

In the Time Editor, The levels Year – Quarter -Month – Month_YTD and Year –Month – Month_YTD create the attribute PriorPeriod. This attribute defines the logical period before the specified YTD element. (#42547)

Jedox Web

Direct access to Jedox Support in Jedox Web

You can now directly access the Jedox Support Portal from within the Jedox application, making it much simpler and faster to report an issue. To use the in-app support function in Jedox Web, users need to set up their OTRS credentials in “Options”. Afterwards, they can access Jedox Support via the help button in Jedox Web and submit the following information:

  • Subject
  • Description (rich text)
  • Jedox component
  • CC (email address)
  • Attached files from the local file system

Additionally, software release number, as well as component version numbers, are passed on automatically, helping Jedox Support staff to respond to issues faster and channel requests more accurately to the right contact. (#42471)

Binary operations on arrays are now handled the same as in Excel

Jedox Web spreadsheets can now handle binary operations (calculations using operators such as +, -, *, /, and ^) on arrays. This allows you to perform calculations on various data types and sizes, for example: =(a1:a3)^{2,3}. (#42310)

Jedox Integrator

Improved load time for Integrator UI

The load time for opening the Integrator UI after restarting the service has been optimized, especially where there are many projects. This is especially helpful for administrators and developers who need constant access to Integrator projects.

For example, in a test scenario with 140 projects, startup time improved from 10-18 seconds (Jedox 19.3) to 5-6.5 seconds. (#41831)

New Field Transform function “Column Aggregation”

This new function performs sum, min, max, or count operations on numeric values from one column and applies them to another column. (#17713)

Optionally, the function can include a third column, and only aggregate those values as long as the value from the third column matches the corresponding value in the previous row.

Simplified connections to files in Jedox File Manager (JedoxFiles)

JedoxFiles connections no longer have the option “Use SSL” in the Integrator Connection UI, as it was confusing to end users. This option is now set by the administrator in a configuration file, components.xml. (#37002)

Improved ordering in Table Aggregation and Table Normalization aggregation functions

Ordering in some aggregation functions has improved. In group_concat, ordering of source lines is now preserved after the transform. In concat_distinct, the ordering of names is preserved from the source file. (#42977)

Changed default values in Integrator configuration file

The following configuration options now have new default values:

removeWriteExecutions: 14 days for executed jobs/loads (previously 30 days)

removeReadExecutions: 2 days for data previews, test, etc. (previously 7 days)

(#43097)

New settings for SOAP connection

There are two new settings for SOAP connections that prevent errors resulting from non-standard policies. “Skip default namespace” and “Ignore policies” are both set with a checkbox; default is unchecked. (#42404)

Set default for null values in DateFormat and Groovy functions

This feature allows defining a fallback value in DateFormat and Groovy functions in field transforms, which is used if the incoming value is “null”.

In DateFormat, you can define a specific date to set in an input field. In a Groovy function, there’s a checkbox: if checked, then a specific fallback for the datatype used in the function is used (e.g. empty string for datatype string, 0 for datatype integer, etc.). (#42630)

Jedox Excel Add-in

ATTN: Native GPU Accelerator Advisor has been deprecated

As announced in Release Notes 2019.3, the native GPU Accelerator advisor has been deprecated. The advisor can now only be accessed through the Modeler dialog. (#42376)

IN PREVIEW: Jedox Office 365 Add-in

Jedox Cloud customers can now test the new Jedox Office 365. The new add-in, which is available “in preview”, enables the use of spreadsheets in the online version of Excel for planning and analysis in real-time across all platforms, including Windows and Mac. Connecting live to the Jedox In-Memory DB, the add-in for the online version of Excel supports full write-back.

New Languages: Romanian and Swedish

The Jedox Excel Add-in 2019.4 now supports Romanian and Swedish languages. (#43165)

Setup & Configuration

New Setup

A new setup that installs only Excel Add-in is available with this version. (#42428)

Technical Health

In Jedox Version 2019.4, the following components were updated:

Component

Version

Apache

2.4.41

PHP (Apache)

7.311

PHP (SVS/SSS)

5.6.39

Tomcat

9.0.22

OpenJDK

11.0.4

 

Tasks implemented since release 2019.3

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

Component

Tickets

OLAP Server

109

SVS

2

Excel Add-in

39

Office Add-in

1

Client Libs

22

Integrator Server

74

Jedox Web

172

Demo content

7

Documentation

73

Setup/CI/CD

87

Jedox Mobile

33

Jedox Cloud

13

Models

69

TOTAL

701