This document gives an overview of the new features, enhancements, and fixes in Jedox Release 2018.2 and in 2018.1.
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 in the final version.
Jedox Release 2018.2
Features in Preview
Starting with version 2018.2, some new features will be labeled “IN PREVIEW” in this document. Our intention is to get your feedback on these features before making them generally available and production-ready. These in-preview features may undergo minor design changes while going through the maturation process. Features that are in preview have undergone testing and have 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.
Jedox In-Memory DB
IN PREVIEW: Optimization for database file storage
A configuration option for Jedox In-Memory DB Server allows storage of cube data on the server’s hard drive only in binary format, not in CSV format. The binary format greatly speeds up the time needed for processing files on the file system in comparison to CSV, such as when the server is shut down. This configuration option is now in preview. It can be used by setting the value “no-csv-save” in the palo.ini configuration file.
New rule template types for subsets
Two new rule template types have been added: global subset element and global subset element (list). These types allow you to build a rule template that will generate instances based on the elements returned by a stored, global subset in a dimension.
New rule template types for grouping elements by attribute values
Three new rule template types have been added. They enable a set of elements to be retrieved from one dimension and additional sets of elements to be fetched from one or more other dimensions based on an attribute pattern. The returned results of these queries are combined into the overall record set for the template.
Information about unprocessed journal files in log
If a database contains journal files that are not in the expected enumeration sequence, these files will not be processed when the server starts. In this case, it will now print an explicit message into the log file and rename the unprocessed file in the database directory.
GPU Accelerator ships with CUDA 9.1 runtime
The Jedox GPU Accelerator is now based on CUDA 9.1, utilizing up-to-date CUDA compilers and runtimes. Please note that this change requires the use of a Nvidia graphics driver with version 390 or higher.
Jedox Web General
Modeler: cube templates create dimension elements
The cube templates in Modeler will now create missing dimensions needed for a given element, including a default set of elements within the dimension.
If the dimensions already exist with the expected name, they will not be re-created, and no elements will be created or modified in them. These dimensions will be used in the created cube.
Confirmation prompt about unapplied changes in Time Editor
When using the Time Editor to make changes in a dimension of type “Time”, a warning will now appear when the user tries to navigate out of the Time Editor without updating the dimension.
Tagging enabled for all file types
Setting custom tags is now enabled for all file types in Report Designer, including Framesets and PDF files. Using tags makes it easier to look for corresponding files.
IN PREVIEW: batch export in PNG format
Besides export of reports in PDF and XLSX format, it’s now also possible to create tasks that will export the report in the PNG image format.
Jedox Web Spreadsheets
PDF export of framesets
In a frameset, several frames can now be selected to be exported as PDFs. The frames to be exported can be selected in the frameset properties by checking them with the “Use for Export” option.
When opening a Frameset in Report Designer, the new dialog “Frameset Page Setup” allows content to be resized by percentage, in which case the content will be exported in the chosen page orientation and format, or by using the “Fit to…” option, which currently only allows the 1×1 setting. When used, the PDF will consist of a single page, showing the original size of the frameset content.
Note that print range settings from individual frames will be ignored if the PDF consists of multiple frames.
Automatic switch of text metrics engine
Jedox Spreadsheet Server’s text metric engine, which determines the required row height and column width based on the spreadsheet content, will now automatically be adjusted to the browser being used, as the accuracy of a machine depends on the browser.
It is still possible to force a persistent text metric engine in the configuration of the Spreadsheet Server.
Function Wizard shows evaluated function arguments
The Function Wizard in Jedox Web spreadsheets now shows the evaluated value of arguments used in the function:
New dialog layout and icons
The layout of the dialogs and new icons in Integrator Manager has been redesigned for better screen use:
Subset filter with array variables in cube and dimension extract
In dimension, cube and cube slice extracts, filters on global subsets can now contain all kinds of subset variables, like array variables for attribute filters. Previously, only scalar subset variables could be used.
Hide empty project groups
As of 2018.2, project groups with no content will not be displayed in Integrator. If necessary, use the Settings Menu to toggle the behavior within a session.
Drillthrough rows have been changed from unlimited to 50,000
In the SVS sample scripts sep.inc.drill_through.php and sep.inc.drill_through_etl.php, which uses Jedox Integrator, the maximum number of rows has been changed from unlimited in older Jedox versions to 50,000. In the named sample scripts, the entry $line = 50000 can be adjusted to your needs. The value for unlimited rows is 0.
SOAP connection: new option for SOAP body
There is a new option “Wrap SOAP body with operation” to support further specific SOAP-based web services.
Basic sets in SAPERPHierarchy extract
Basic sets as defined in the SAP component Special Purpose Ledgers (FI-SL) can now be retrieved with the extract type SAPERPHierarchy.
Security of script jobs and functions
Jedox Excel Add-in
New Connection Assistant
The Connection Assistant in Jedox Excel Add-in has been redesigned. There is now only a single type of Connection. The connection properties consist of settings for both connection to the In-Memory DB Server (such as from the Paste View dialog) and Jedox Web (such as in the Modeler).
Existing connections will be converted to the new Connection Assistant.
Adding TLS client certificates in the Excel Options dialog
The client certificates required for secure communication with the Jedox In-Memory DB Server can now be edited via the Options dialog in Jedox Excel Add-in.
Automatic Java installation has been removed
The Jedox Windows Setup 2018.2 does not automatically install the needed Java Runtime Version 8.
If this software is not found, you will receive the following message, prompting you to download the software from the Java website:
If a higher version of Java Runtime Environment is found, then make sure that the Jedox installation uses Java Runtime Version 8.
New software requirement: Visual C++ 2017 Redistributable
Jedox Windows Version 2018.2 requires additional software, Visual C++ 2017 Redistributable. If Visual C++ 2017 Redistributable is not installed on the target computer, the Jedox Windows Setup 2018.2 will install it automatically.
Jedox Release 2018.1
Beginning with this release, Jedox is introducing new release naming policy. Public release names will now be in the format <YEAR>.<NUMBER>. The current release is thus named 2018.1.
Internal version numbers in the form <MAJOR>.<MINOR>.<PATCH>.<BUILD>, e.g. 188.8.131.5230 will be kept where applicable, as shown in the screenshot below:
Beginning with this release, Jedox is aiming at delivering 4 releases per year.
It is now possible to store Jedox Views on the server as a global view (accessible for all users) or as a private view (accessible only for the current user). Thus, a Jedox view definition can be stored centrally, and the Jedox View will then be available simultaneously on all frontends (Excel Add-in, Jedox Web, Jedox Mobile) that have access to the server.
As of 2018.1, calculation and caching of effective rights has been rewritten to better address complex scenarios where effective rights calculation would take a long time, such as environments with many users (hundreds+), groups, and detailed rights settings.
As of 2018.1, private tasks are no longer supported. It is not possible to create new private tasks or change existing tasks to private.
As of 2018.1, the autocomplete option in Macro Editor is turned off by default. In previous Jedox versions, it was turned on by default and, for example, automatically added closing brackets when starting brackets were entered.
This option can be switched on and off with a new button in the toolbar of the Macro Editor, as shown below:
In the relational database used for the persistence of the drillthrough data, the schema and table may now have names that are not in upper case.
The same goes for the table columns; the column names must match dimension names only in a case-insensitive way.
The Jedox Setup 2018.1 supports Estonian and Serbian as new languages.