Release Notes 2019.2

This document gives an overview of the new features, enhancements, and fixes in Jedox 2019.2, which is currently available at www.jedox.com. 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.

We’ve made some changes to this document. The most obvious change is the title: we changed it from What’s New to Release Notes, which is more consistent with software industry standards. We have also added a reference number (e.g. #12345) to the end of each entry that can be used in communication with Support.

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. Note: as of version 2019.2, you can enable and disable most IN PREVIEW UI features in Jedox Web Administration by adding a new Boolean key: features.rollout.preview.

Jedox features with the heading ATTN include changes that may impact settings in your current installation.

General

Jedox software now updated nightly

As of version 2019.2, Jedox software is now updated nightly and will include the latest hotfixes. Note that major releases will still take place on a quarterly basis.

UI/UX

Custom thumbnails on the recently opened list in Reports

You can now see the custom thumbnails set for each report on the recently opened list in Reports. (#40384)

Redesigned Paste Elements window

The plus/minus buttons for opening and closing the next hierarchy level in the Select Elements window have been removed. (#40486)

Subset list has moved to the top of the dialog window.

The window is now optimized to display very large dimensions: when expanding all elements, the dialog displays a limited number of elements, revealing more as you scroll through the list.

Simple Ribbon is now the default toolbar

The Simple Ribbon (shown below) is now the default toolbar for spreadsheets and reports in Jedox Web. The Toolbar and Ribbon options can still be manually selected in the Options dialog. If your current Jedox installation has a different ribbon set as the default, this selection will be maintained when you upgrade to Jedox 2019.2. (#40628)

Note: the Toolbar and Ribbon options are deprecated and will be eliminated in Jedox 2019.4.

Further changes to the Simple Ribbon

  • There is now a Save button on the left-hand side of every tab of the Simple toolbar (#40012)
  • Some of the “button menus” have been organized into explicit button groups. (#40382) These buttons contain only icons (no text labels) with tooltips:

Changes to Paste View

  • Stored Views are now displayed as an expand/collapse tree.

  • There is a shortcut for Stored Views on the ribbon, allowing you to paste and edit them. This option is available both in Jedox Web and Jedox Excel Add-in. (#40012)

    Jedox Web

    Excel Add-in


Changed click behavior for ESELECT cells in Jedox Web

A single mouse click on a Jedox Web spreadsheet cell containing a PALO.ESELECT formula now opens the element picker dialog in user mode. The mouse cursor has been changed to a pointing hand when hovering over such a cell in user mode. (#40392)

Changed click behavior in User Mode

In Jedox Web, when you view a report in User Mode, a single mouse click now expands and collapses the rows and columns. The cursor changes to a pointing hand when you hover over an expandable collapsible element. (#400030)

Active language now applied to login screen

The login screen now appears in the language set in the Options menu. (#40669)

In-Memory DB (OLAP)

Automatic asynchronous database autosave

This new autosave feature automatically saves databases in intervals controlled by the server itself. These intervals can be changed in the configuration file palo.ini. Note: the previous autosave function, set in palo.ini, is now obsolete. (#37702, 41110)

A few highlights of automatic asynchronous database autosave in Jedox:

  • Autosave is nonblocking, i.e., users can read and write to the server while save is running.
  • It is fully controlled by the server to prevent big journals from being created to enable fast server restart and minimize problems during journal processing.
  • It saves all changed objects automatically 5 minutes after the last completed autosave.

New palo.ini key for disabling group fetching

The new palo.ini key windows-sso-ignore-groups disables group fetching in authentication. When activated, arrays with group names are not retrieved from AD, so SVS authentication script receives empty array with group names. It can speed up the authentication process when users are assigned to many groups. (#40758)

Performance optimization for simple formulas

Jedox In-Memory DB no longer caches simple formulas, which saves memory and speeds up calculations. Now smarter caching has been implemented for simple static rule calculations. (#38621)

For example, the following formulas have been optimized:

[‘actual’]=STET()

[‘actual’]=1

Spacer elements in Subset Editor picklist

You can now select spacer elements in the Subset Editor to add empty rows to Views or DynaRanges. These spacers can add structure to data tables. (#40202)

Note that the spacers will work specially in subset which are configured to return flat lists. They can also be used on hierarchical subsets, but will then impact the expand/collapse behavior in Views or display in Web DynaRanges and comboboxes.

Change for access rights in context of stored views

The required role rights for granting users access to stored view have been changed. It is not required anymore to grant a user’s role “W” or “D” access to the “dimension element” right object in order to give them the ability to create or delete stored views. “R” access to dimension element is still required. (#39899)

ATTN: attributes for #_#_VIEW_ dimension properties changed

The attributes of the internal #_#_VIEW_ dimension, which is used to store properties of views, will be automatically changed by the In-Memory DB during startup. The type of the attribute “Friendly Name” is changed from “numeric” to “string”.

The change will not impact properties of existing views, although it could have an impact if the attribute type is read in any customized code. (#40401)

IN PREVIEW: lightweight GPU

The internal architecture of the GPU Accelerator has been redesigned for more efficient memory usage. Calculations on cubes converted to GPU now use the same storage structure as CPU calculations, which also greatly improves the speed of converting a cube to GPU. (#39653)

Although in preview, this feature is fully usable, and no manual migration steps are required. Note that the configuration options gpu-data-storage and gpu-dim-order for the In-Memory DB are now obsolete.

Jedox Web

ATTN: Support for Internet Explorer 11 ending in upcoming release

As of the next Jedox release (2019.3), Internet Explorer 11 will no longer be supported. Instead, Jedox will support use of Microsoft Edge. (#39744)

Performance optimization of Element Picker for large dimensions

The Select Elements dialog in Jedox Web has been further optimized to handle large and complex dimensions (e.g. large time dimensions). The dialog (used in Spreadsheets, but also in the advanced area of the Rule Editor, in “Clear Cube” dialog etc.) will now load elements progressively as you scroll down the list, rather than load the whole list at once. Searching for specific elements on such dimensions is also improved. (#39966)

IN PREVIEW: Subset Editor dialog checks for default subset

A stored subset can now be flagged as the default for a dimension in the Subset Editor. (#40252)

When opening Subset Editor on new ComboBoxes, DynaRanges, etc., the dialog checks for existence of flagged default subset and selects it if found.

Changing the element order in Picklist Subsets

When you use the Picklist Tab in the Subset Editor, you can set the order of the elements you want to add to the subset. (#40192)

Note: feature is not supported for Picklist behaviors Merge in the list and As preselection for the subset.

Show Now button in Paste View dialog

In the Paste View dialog, if Show Now is turned on, you can now see the effect of those changes in the sheet. (#40260)

IN PREVIEW: stored Views can be flagged as default

You can now flag a stored view as default from the Cubes section in the Modeler. (#40259)

Global and private Subsets visible in Modeler

You can now see all the global and private Subsets available (according to your user rights) in Modeler. After selecting the subset, the filtered results appear. The option is available as a searchable ComboBox. You can also edit these subsets on the fly. (#40015)

Supervision Server Script Editor now in Jedox Web

The Supervision Server Script Editor is now available in the Jedox Web Modeler. The editor allows you to access every available SVS script, make changes to it and restart the Supervision Server. (#39827)

Zero suppression behavior in Paste View has changed

In the Paste View­­→Select Elements dialog, the zero suppression checkbox is now disabled in the dialog. Unless it is selected, the elements tree is no longer filtered (i.e., it shows all elements, including zero elements). (#38412)

This behavior is now consistent with that in Excel Add-in.

New GPU Accelerator Advisor dialog in Modeler

The GPU Advisor has been redesigned and is now available in the cube properties tab of the Jedox Web Modeler. (#39829)

Integration of nanodbc library in odbc extension

New library follows new C++ standards and solves issues with technical debt. (#39701)

Extended list of custom formats in Format Cells dialog

There are five additional formats in the Format Cells dialog:

Percentage: #,##0.00%;[Red](#,##0.00%);-

Thousands: #,##0,”K”;[Red] (#,##0,”K”);-

Millions: #,##0.00,,”M”;[Red] (#,##0.00,,”M”);-

2 decimals: #,##0.00;[Red](#,##0.00);-

Hide cell content: ;;;

Changes in the way Stored Subsets are displayed

Stored Subsets are now displayed as an expand/collapse tree. You can select a stored subset and make changes to it by clicking on it once. Clicking on it again reverts the Subset Editor to standard settings. (#40008)

Paste PALO.SERVER_SUBSET() formulas from the Subset Editor

The Subset editor now offers two paste options: Paste and Paste Stored, the latter only being active when a stored subset is selected and has not been modified. Paste inserts a PALO.SUBSET() formula using the stored subsets settings. Paste Stored inserts PALO.SERVER.SUBSET(). (#40369)

New way of generating dynamic web reports in PDF

Jedox Web now uses a different backend component for generating PDF exports of Jedox Web Reports. As a result, generating PDF content for Widgets which use JavaScript in ECMAScript 6 syntax is now supported. (#39615)

Optionally exclude CSV files when you download or schedule a backup for a database

In the Modeler, when you download a database or schedule it for backup, a new option in the corresponding dialogs allows you to also include CSV files. This option is selected by default (see screenshot below). If the option is not checked, the download or backup will only include .bin files, which are faster to generate, but do not allow transfer between Linux and Windows. (#40497)

Keyboard shortcuts on input cells are changed in designer and user mode

The keyboard shortcuts on for input cells in designer and user mode are now in line with Excel and designer mode:

  • Shift + Enter closes the current cell if input mode is active and selects only the one above it.
  • Shift + Tab closes the current cell if input mode is active and selects only the one on its left. (#40408)

Cell Tracer now available in Jedox Web spreadsheets

The Cell Tracer dialog, which can be used to trace the origin of calculated values in PALO.DATA* cells in reports, is now available in Jedox Web as well as Excel Add-in. The dialog can be accessed in Report Designer by right-clicking on a PALO.DATA* cell. (#40970)

Enable IN PREVIEW enhancements

You can enable and disable most IN PREVIEW UI features in Jedox Web > Administration by adding a new Boolean key: features.rollout.preview. (#40988)

Note: the settings only controls features that are part of the Jedox Web user interface, but not other frontend or backend components.

Jedox Integrator

ATTN: Function type Java has been deprecated 

As announced in What’s New 2019.1, the FieldTransform function of type Java was being deprecated. It no longer works as of this version (2019.2). The Groovy Function can be used instead.

New load type: CubeSliceCopy

With this load type, you can copy the values from one cube slice to another in an Integrator job. It can also perform “like” operations. The new load will execute the copy operation in In-Memory DB itself, without first reading values. See CubeSliceCopy Load for more information. (#39589)

New options for scientific notation in Integrator jobs

In File Load, there is now a Boolean option to display data with or without scientific notation. Default option is to use scientific notation.

In Cube Extract, numerical cell values are formatted with purely decimal notation instead of scientific notation for very large or small values. Note that this formatting does not apply when cell type has been designated as “only numeric”, because the value column has a numerical data type. (#39304)

Extended options for Java API/Groovy database backup

The Java API IDatabase.backup, which executes online backup of OLAP, has been extended to support additional parameters. (#38962)

ATTN: default configuration for retaining Integrator job logs

The default duration for keeping log files of Integrator jobs/loads has changed from 100 days to 30 days. Note: execution logs that are older than 30 days will be removed, unless the default value is changed. (#40580)

New Integrator API ICube.loadCell

There is a new API, ICube.loadCell, for writing a single cell to an OLAP cube. This API is useful if a value change from an Integrator project is protocolled in the Audit dataset of a cube. (#39076)

Note: written with the existing API, ICube.loadCells, are excluded from the Audit dataset.

Remove unused components

This new option, available through a project’s context menu (see screenshot below), identifies and removes unused components from an Integrator project. You will see a confirmation screen before any changes are made. (#35904)

Additional Scheduler templates for Integrator job status

The Scheduler now has two additional templates: ${etlJobStatusCode} and ${etlJobStatus}

These templates let you include a status code (eg. 10 or 30) and a string representation of that code (eg. “Completed successfully” or “Completed with Errors”) in automated status messages. (#40447)

Aggregation on integers in some table transforms

Integer measures are now allowed for table aggregation, table normalization, and table denormalization transforms. (#39785)

Show the value of project variables

You can now inspect the current value of Integrator variables. To do this, click Show value on the toolbar. This option is useful for variables sourced from Settings Manager or a Groovy script. (#38864)

Jedox Excel Add-in

SUCCESS Charts can now be displayed without Excel Add-in

Success Charts that are exported as xlsx snapshots from Jedox Web can now be displayed in Excel without installing the Excel Add-in. (#37053)

Several dialogs switched to web-based version in Excel Add-in

In Jedox Excel Add-in, the following dialogs are now displayed from Jedox Web: Paste Data Function dialog, Planning Assistant, Hold Manager, and Data-Driven Modelling. For now, you can opt to continue to use the legacy versions (see next entry). (#39824)

The web-based Subset Editor, in preview since 2019.1, is now generally available (GA).

New option to enable/disable web dialogs

In the Options dialog of Excel Add-in, there is now an option to enable (default) or disable all dialogs that have recently been replaced by web dialogs. These dialogs include Paste Data Function, Subset Editor, DDM, Planning Assistant, and Hold Manager. If the option is disabled, the legacy versions of the dialogs are used. (#40459)

Note: the legacy versions of these dialogs are deprecated and will be removed in a future version.

Import Wizard deprecated

The Import Wizard in Jedox Excel Add-in is deprecated in version 2019.2. It will be removed from Excel Add-in in an upcoming release. Imports can still be performed with Data-Driven Modeling or Integrator. (#39833)

Supervision Server script editor accessible from Excel

The Supervision Server dialog can now be accessed by clicking on the cog wheel in the Modeler, as shown below:

This will open the script editor in a Jedox Web dialog. Note: the native Excel SVS editor is deprecated and will be removed in an upcoming release. The web dialog described above will continue to be available. (#39827)

GPU Advisor deprecated in Jedox Excel Add-in

The GPU Advisor in Excel Add-in is deprecated and will no longer be available after Jedox 2019.3. The new GPU Advisor will be available in the Jedox Web Modeler (see above). (#39829)

Detach view and Paste Data Function use PALO.EL syntax

Detach View and Paste Data Function now generate formulas with PALO.EL syntax, which allows you to see values in offline mode and keeps formulas valid if the cube layout changes. (#40676)

“Show now” in Paste View

The Paste View dialog now has a new preview feature, Show now. When selected, you can see real-time changes to your spreadsheet as you build the view with the dialog. To implement the changes, click Paste View. To discard the changes, simply close the dialog – the View will not be pasted, and contents that were modified with the dialog will not be retained. (#40508)

Setup

RPC and Integrator as separate Tomcat processes on Linux

The two backend components RPC and Integrator are now executed in two separate instances of the Tomcat server in Linux environments. This allows for separate configuration and monitoring of the two components. (#40036)

ATTN: Linux setup: “–no-deps” deprecated for start script

The option –no-deps for the script Jedox-suite.sh is deprecated and will raise an error if used. (#41183) See Start/Stop on Linux for more information.

Changed log location for Integrator

Integrator now writes log files to the subdirectory “tomcat-etl” within the configured log directory on both Windows and Linux installations. (#40825)

New parameter for silent setup

The new parameter /CONNFILE copies a specified file to the Excel installation directory in Jedox Suite and into the Excel directory in %APPDATA%. It will create a backup of the original file in %APPDATA% before overwriting it. This parameter must be used with /SILENT and /LOADINF. (#41170)

Technical health

In Jedox Version 2019.2, the following components were updated:

Component

Version

Apache

2.4.39

PHP (Apache)

7.2.18

PHP (SVS/SSS)

5.6.39

Tomcat

8.5.40

MS Access

3.0.0

MSSQL

7.2.0.jre11

Tasks implemented since release 2019.1

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

Component

Tickets

OLAP Server

112

SVS

0

Excel Add-in

61

Office Add-in

1

Client Libs

9

Integrator Server

75

Jedox Web

291

Demo content

9

Documentation

112

Setup/CI/CD

60

Jedox Mobile

54

Jedox Cloud

63

Models

35

TOTAL

882