The Jedox development team has introduced the second service release of the latest Jedox version 6.0. The release SR2 comprises new features, tweaks and bug fixes, providing Jedox users with improved system stability and performance. Numerous optimizations within the Jedox Excel add-in and MS Office integration further enhance the usability and help making planning, data analysis and reporting with Jedox even more comfortable and efficient.

Jedox OLAP

ATTN Breaking Change: OLAP Accelerator (GPU) CUDA toolkit version change
The CUDA toolkit used for Jedox OLAP Accelerator (GPU) has been updated to version 7.5. An update of the NVIDIA driver is mandatory due to this change. On Windows, the latest driver can be used. On Linux, the driver from 7.5 toolkit should be used.

New goalseek mode: transfer
A new mode is available in goalseek splashing: transfer. This mode allows to transfer from one element to another within one dimension; the subtotals in all other dimensions will stay fixed on their current values after the transfer. The target of the transfer can be a single element or a set of elements. The mode is available in Splashing Wizard in Excel Addin, or can be used on cell inputs by using the “to” keyword, followed by the target element(s), for example, on a cell for element “January” in a month dimension: “500 to February”.

Jedox Web

ATTN Breaking Change: optimization for Conditional Formats in DynaRanges
The usage of conditional format rules in DynaRanges has been optimized. If a CF rule is applied on all rows of a vertical DynaRange, or all columns of a horizontal DynaRange, it will not be copied into multiple rules anymore once the DynaRange is activated (for example in Report Manager). Instead, only the ApplyRange of the rule is modified accordingly.
This change implies that in such rules, the correct type of cell reference (relative or absolute) has to be used. For example, an absolute reference (using $ characters) will now always point to the exact referred cell in such a rule; previously, the reference was adjusted as copies of the rule were created in the DynaRange.

Support for PALO.ESELECT() function
Jedox Web now supports the PALO.ESELECT() function. The function was introduced in Jedox Excel AddIn in version 6.0. It allows specifying a stored subset, which is used to filter element lists shown in the “Select Element” dialog. Additionally, it allows specifying an Alias and an Alias format. Long element lists on specific dimension level are displayed in paged mode. The search in both “Paste Elements” dialog and “Select Element” dialog will now search across the full dimension. Existing PALO.ENAME() formulas will automatically be converted to ESELECT formulas if the Element Picker is used on them.
Usage of the element picker on ESELECT cells is also supported in reports viewed in the Jedox Mobile app.

Configurable size of olap element lists in spreadsheets
The length of element lists retrieved from Olap Server in Jedox Spreadsheets (for example, PALO.SUBSET feeding a combobox) by default is limited to 65336 elements. This limit can now optionally be changed. To change the limit, add a new entry “max_result_size” in palo_config.xml, in the <palo_configuration> element, for example: <max_result_size>256000</max_result_size>

Option to disable Comments panel
A new global option in Jedox Web Settings Manager allows disabling the Comments panel for all Files and Reports. The option can be found in Settings Manager section “Collaboration”. Disabling comments will hide the Comments panel on all reports and files. Existing comments are not deleted. If the setting is changed to show Comments again, previously existing Comments will be visible again.

Option to increase quality of Widgets in PDF
A new global option in Jedox Web Settings Manager allows increasing the quality of Widgets in PDFs. To use the option, add a new key in Settings Manager called “spreadsheet.widget.print_quality_factor”, of type “float”. The default value for the key is 1.0. For higher quality of Widgets in PDF’s, you can increase this value. Values higher than 3.0 will only achieve very minimal changes. When increasing the factor, the size of the output PDF file will also increase.

Please note that the quality also depends on the content of the Widget, the Page Setup settings, the used PDF Viewer and possibly the used printer.

New Spreadsheet Function NETWORKDAYS()
Support for the function NETWORKDAYS() has been added in Jedox Web Spreadsheets. The function works in similar fashion to MS Excel, calculating the amount of working days between a start date and an end date. A single date or list of dates to be excluded from the calculation can be specified optionally.

Extended options for external Report Links
When generating external links to Jedox Reports via a Report’s properties dialog in Report Manager, there are additional options available for “Standalone” links.

You can

  • disable Scrolling
  • disable the Sheet Selector
  • disable “pinch” zooming in Mobile environments

Continuous page numbers in Batch PDF
The Batch PDF Wizard now allows to define PDF header settings for the page and overall number of pages in a Batch PDF. When set in Batch PDF Wizard, the page number will be continuous for the whole generated PDF, and not restart at “1” for each report included in the report.

Additional feature for Conditional Formatting: “Dates Occurring”
A date can now be formatted depending on whether it is “Yesterday”, “Today”, “Tomorrow”, etc.

The screenshot shows all possibilities:


Jedox Integrator

New connection Mongodb
With this connection type it is possible to connect to the document-oriented database MongoDB which stores all data in documents with dynamic schemas and JSON-like field and value pairs.

GenericDB connection
The specification of the driver class of the JDBC driver is no longer obligatory. It only has to be set for legacy JDBC drivers which are not JDBC 4.0 compliant.

New extract Mongodb
This extract type can query data from a MongoDB.

Technical Health
In 6.0 SR2 following target platforms have been added to the supported list:

  • Microsoft Office 2016
  • Windows 10

Author: Vladislav Malicevic