What’s New in Jedox 7.1

image_pdfimage_print

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

Jedox OLAP

Upload and download of databases

Databases can now be uploaded to and downloaded from the OLAP Server while it is running. The interface for this feature is added in the Jedox Web Modeler:

Holding cell values

Jedox OLAP Server now offers the ability to define holds on cube cells. When a hold is defined, the value in the cell is fixed and will not be affected by writeback operations occurring above the cell. Holds are persisted in the server across sessions.

New Data-Driven Engine (DDE) supported features.

In Jedox 7.1, new Data-Driven Engine (DDE) supported features have been implemented, e.g. full DDE support of the following rules functions: SUM, MIN, MAX, AVERAGE, MEDIAN

These improvements reduce the calculation time by 8% (based on a benchmark set of 42 real-life database models).

New performance monitoring features in OLAP built-in administrator

As a new feature, the OLAP built-in administrator displays the following rules statistics:

These numbers can help to find performance issues related to handling expansive data and calculating formulas with no result.
This feature is one of several new displays of the OLAP built-in administrator that help to analyze computing processes.

New OLAP cache default size

In palo.ini, the default value for the cache barrier has been changed from 1,000,000 to 100,000,000.

Details of progress on processing journal files

As of Jedox 7.1, you will find information on journal processing in log, as shown in the sample below:

2017-05-16 14:30:25 INFO: [system] found non-empty journal in database Test, processing started
2017-05-16 14:30:42 INFO: [system] Processing journal, 68 % done, line 32531, command ELEMENT_APPEND
2017-05-16 14:31:02 INFO: [system] Processing journal, 73 % done, line 32581, command ELEMENT_APPEND
2017-05-16 14:32:06 INFO: [system] Processing journal, 78 % done, line 32583, command ELEMENT_APPEND

GPUs with Compute Capability 2.0 and 2.1 are deprecated

In Jedox 7.1, GPUs with Compute Capability 2.0 and 2.1 are no longer supported.

 

Jedox Web General

ATTN Breaking Change: report export options can be disabled

Certain options for the export of reports as WSS or XLSX files can now be disabled for users with restricted access to the Reports panel. If a user’s role only has “R” (read) access for the ste_reports rights object, the options to export a report as WSS file, as XLSX OLAP snapshot, or to create batch XLSX tasks are now disabled. The option to export as XLSX snapshot is still available.
If the user has “W” (write) access to the ste_reports rights object, these export options will be enabled. However, this user will still see the hierarchies in the Reports panel in read mode, meaning that report hierarchies cannot be changed, added, new reports created, etc. These capabilities are only enabled for users with “D” (full rights) access on the ste_reports object.

UI design changes

As of 7.1, the login page and the home screen have been redesigned:


New login page

Furthermore, a new icon set is used in all Jedox Web components.

Update for Jedox Marketplace

The Jedox Marketplace has been completely redesigned in Jedox 7.1. Besides allowing installation of models, it is now also possible to run a “Test Drive” of certain models (in a temporary, cloud-based test environment) to preview a model’s functionality, or to watch videos highlighting model functionality.

Multiple instances of models

It is now possible to install a single model several times within the same Jedox platform environment. During installation, the user can select a so-called “namespace” to install the model in, and, if picking a different namespace, can install the same model side-by-side with an existing installation. Please note that database scripts will by default target the same database during installation, so it may be necessary to pick a different database name during the installation.

New Jedox Web UI languages

The Jedox Web 7.1 User Interface now supports Danish, Hebrew, Korean, Persian, and Turkish.

Upload and download of databases in Modeler

You can now download a zip archive of a database from the Modeler via the context menu of the database node. You can add a password to the zip file, and optionally include archived files and the system database.  Also, you can upload zip archives with databases without the need to restart Jedox OLAP Server.

Normalization can be done by any dimension in Upload Wizard

As of Jedox 7.1, normalization can be done by any dimension in Upload Wizard. In previous versions, normalization was restricted to the Measure dimension.

Usage of defined Default Read Element”

The Default Read Element for a particular dimension can be defined in the Dimension Properties tab of the Modeler, under the Settings section. As of Jedox 7.1, that Default Read Element will be used in the header of Jedox Views in both Excel spreadsheets and Jedox spreadsheets.
Jedox Views that are created after the Default Read Element is defined will be automatically updated. Jedox Views that were created before a Default Read Element is defined will not be influenced by the Default Read Element setting. 

Attribute domains

For dimension attributes, domains of valid values can now be defined. Several value types (Boolean, integer, but also subsets, etc.) can be used.
Depending on the chosen domain and settings, the Elements Grid in Modeler will offer customized controls for input of attribute values, such as a checkbox for setting Boolean values.

Default clause for database scripts has changed

When creating database scripts from the Modeler, the scripts now use the NO_ERROR clause by default, instead of ERROR_IF_EXISTS. This clause allows re-running a script on the database in which it was created.

Drag-and-drop of elements in Modeler

Dimension elements can now be modified using drag-and-drop in the elements list in Modeler. Drag-and-drop can be used to reorder the elements, to move elements into a different place in the dimension hierarchy, or to add elements in additional hierarchies.

Time Editor: YTD/YTG elements in separate hierarchies

The Time Editor now allows you to create optional YTD or YTG elements in a hierarchy branch parallel to the normal time hierarchy.

Search-as-you-type in the parent element combo box in Modeler

The combo box for selecting an elements parent now supports search, and shows results live during the text input, as shown in the screenshot below:

Syntax highlighting in Advanced Rule Editor

As of 7.1, syntax highlighting is implemented in the Jedox Advanced Rule Editor.

Auto-completion in Advanced Rule Editor

It is now possible to use auto-completion when typing a rule formula. The auto-complete feature is activated by using <CTRL>+<SPACE> key combination:

Extended copy and paste capabilities in Modeler

Copy and paste in Modeler has been extended to also support attribute values.

Private tasks in Scheduler deprecated

Private tasks in Scheduler are officially deprecated with version 7.1. Private tasks are no longer supported. Global tasks should be set up instead. Private Tasks will cease to function with the next major version of Jedox.

 

 

Jedox Web Spreadsheets

ATTN Breaking Change: automatic conversion of classic charts to dynamic charts

Workbooks that still contain classic charts of the legacy chart engine will be automatically converted on first load in Jedox 7.1, and the charts will be updated to dynamic charts. For some charts, this implies mapping to a different chart type, as some of the legacy chart types are not supported anymore.

New Planning Assistant

The Splashing Wizard has been replaced by the newly designed Planning Assistant. In addition to the capabilities of the Splashing Wizard, the Planning Assistant can also define holds.Planning Assistant

Defining OLAP holds

In addition to defining cell-value holds with the new Planning Assistant, holds can also be defined by selecting Hold Manager from the context menu of an (unlocked) PALO.DATA* cell. The new Hold Manager dialog also shows which holds are defined for a specific cell and allows holds to be released.

OLAP undo functionality in Jedox Web reports

The undo functionality of writeback in the Jedox OLAP Server is now also accessible from Jedox Web reports. It can be accessed from the toolbar menu when data cells are selected.
In addition to functionality known from Jedox Excel Add-in, Jedox Web undo functionality offers the ability to pick up an undo lock from a previous session and revert, rollback, or commit the changes from that undo lock.

Hiding dimensions in View headers

Dimensions that are placed in the header section of a View can now be hidden. To hide a dimension, uncheck the box next to the dimension in the POV area of the Paste View dialog (as shown below).

Usage of defined Default Read Element

The Default Read Element for a particular dimension can be defined in the Dimension Properties tab of the Modeler, under the Settings section. As of Jedox 7.1, that Default Read Element will be used in the header of Jedox Views in both Excel spreadsheets and Jedox spreadsheets.
Jedox Views that are created after the Default Read Element is defined will be automatically updated. Jedox Views that were created before a Default Read Element is defined will not be influenced by the Default Read Element setting. 

Revised number format engine

The internal definition and storage of cell number formats has been revised to more closely match patterns from MS Excel.

Deleting multiple conditional formatting rules

The Conditional Formatting dialog now allows to delete several rules at once. You can select multiple rules by using either CTRL or Shift keyboard key and clicking the rules. When clicking “Delete” button, all selected rules will be deleted.

Subset Editor: new Siblings button in HFilter

The Web Subset Editor now offers to return only siblings in HFilter, i.e. elements on same level.
If this button is set, other level definitions in Hfilter will be ignored. Therefore, the “Filter elements by level” checkbox should be unchecked.
Note: this feature was already available in Excel Add-in Version 7.0 SR2.

Subset Editor: relative levels in HFilter

The Web Subset Editor now allows you to define a relative level setting in HFilter. When used, the element hierarchy is filtered per level relative to the selected element.
Note: this feature was already available in Excel Add-in Version 7.0 SR2.

Subset Editor: ability to control regex filtering in AFilter

The AFilter tab in the Web Subset Editor now allows you to control the usage of RegEx filtering. 
Note: this feature was already available in Excel Add-in Version 7.0 SR2.

Subset Editor: control start and length of subset

In the Sort tab of the Web Subset Editor, it is now possible to define the maximum length (number of elements) of the subset results. Additionally, you can define at which position in the subset element list the returned result should start. 
Note: this feature was already available in Excel Add-in Version 7.0 SR2.

New Jedox Spreadsheet functions

The following functions have been added in Jedox Spreadsheets:

  • GROWTH()
  • LINEST()
  • LOGEST()
  • REGRESSION()
  • TREND()

Vertical Waterfall SUCCESS Chart

A new chart has been added to the SUCCESS Charts, the Vertical Waterfall chart. In addition to the features of the Horizontal Waterfall chart, it offers additional configuration options, such as the ability to denote certain bars in the chart as subtotals.

 

Jedox Integrator

Execution runtime details

Integrator now can show runtime details for the execution of jobs, such as the exact timing of each component that was processed during a job’s execution. The details can be inspected from the job execution monitor, shown below:

Execution runtime details

Creating linked components

It is now possible to create new components which directly link to an existing component. For example, you can create a new “FieldTransform” directly from an existing extract; the transform will automatically use the extract as a data source.

Creating linked components

Project documentation

Documentation for an Integrator project can be generated as a PDF or a RTF file.

Integrator supports the handling of holds

As of Jedox 7.1, the Integrator can define, remove, and export holds.

Fill variables from Settings Manager and from Scripts

Project variables can now fetch the default value from a key in Settings Manager. Settings from type ‘password” can be used as variables for encrypted input fields. The variable default value can also be defined with a Groovy Script.

Variable tracking in integrator projects

As of Jedox 7.1, FlowGraph will display where a specific variable is used in the project:
After selecting the variable “_SourceRef”, the flow graph displays all modules that use this variable.

Locations in file based connections

In connection types File(CSV), XML, JSON and Excel, additional locations for file storage are available:

  • The former location URL is split in 7.1 on protocols to HTTP, FTP, and WebDAV.
  • Location FTP supports now FTP in active mode and loading to a FTP Server.
  • Location OneDrive allows Read- and Write-access to the file-hosting service One Drive operated by 
  • Location WebHDFS supports Read- and Write access to the Hadoop Distributed File System.

Hadoop integration as part of setup

Until Jedox 7.0, an additional package had to be installed for connectivity with Hadoop. Now the connector is included in the standard Jedox Setup. It supports the version HDP 2.5 of the Hortonworks Data Platform. The connection type “HDFS” for CSV files has been replaced with a WebHDFS location.  This also supports XML, JSON, and XLSX files.

REST connection enhancements

In REST connections, new options for OAuth2 with password credentials and for timeout are available. The test of a REST connection now displays the HTTP response in case of a successful test (also for connection type SOAP).

New extract Qlik

Extraction of data from Qlik Sense Server is possible in Integrator 7.1.

New transform type TreeElement

With this new transform type, it is possible to use all functions of the FieldTransform directly on tree-based sources. This allows the creation and modification of attributes, the usage of hierarchy information such as number of children inside of functions, and the modification of the tree structure.

New transform type FieldNormalization

This transform type allows the normalization of a source with concatenation in one column, separated by a character or a regular expression.

Dynamical columns in transforms

In the transform types FieldTransform, TableAggregation, TableNormalization, and TableDenormalization, the output columns can now be defined dynamically with two new options: Column Include Pattern and Column Exclude Pattern. The same goes for measures in the last three of these transforms, with options Measure Include Pattern and Measure Exclude Pattern.

Various minor enhancements in transforms

  • TableJoin: enhanced join conditions.
  • TableView: filter empty rows.
  • TableAggregation: keep source ordering.
  • TableAggregation: new aggregate function “count_distinct“.
  • FieldTransform, function Groovy: aliases can be defined for input fields.

Preview enhancements

The preview of an extract or a transform shows also the column datatypes as a tooltip. It supports sorting and filtering. A preview is now possible from within the Function editor.

Monitor enhancements

In the execution monitor, it is now possible to filter logs on the log level and to remove executions.

SAP transport packages with own namespace

The objects of the SAP transport package now have the dedicated SAP namespace “/JDX/”. 

 

Jedox Excel Add-in

Vertical Waterfall SUCCESS Chart

A new chart has been added to the SUCCESS Charts: the Vertical Waterfall chart. In addition to the features of the Horizontal Waterfall chart, it offers additional configuration options, such as the ability to denote certain bars in the chart as subtotals.

Hiding Dimensions in View Headers

Dimensions that are placed in the header section of a View can now be hidden. To hide a dimension, uncheck the box next to the dimension in the POV area of the Paste View dialog (as shown below).

Usage of Default Read Element in Views

If a Default Read Element is defined for a dimension, and this dimension is used in the header of a View, the Default Read Element will automatically be used as the selection in the View header, unless the user explicitly selects a different element.
The Default Read Element will only be used in new Views. Existing Views will not switch automatically to this element.

Defining OLAP holds

In addition to defining cell-value holds with the new Planning Assistant, holds can also be defined by selecting Hold Manager from the context menu of an (unlocked) PALO.DATA* cell. The new Hold Manager dialog also shows which holds are defined for a specific cell and allows holds to be released.

Disabled Zero Suppression in row/column element selectors

When using the element selectors on dimensions in rows or columns of a View, the list of elements will not be filtered anymore if zero suppression is turned on. This allows selecting elements that are currently empty but which might get values at a later point in time. Element selectors on the header dimension still show the filtered element list.

New Planning Assistant

In both Jedox Excel Add-in and Jedox Web, the Splashing Wizard has been replaced by the newly designed Planning Assistant. In addition to the capabilities of the Splashing Wizard, the Planning Assistant also adds support for Transfer and Hold modes.

Adjustment for high-resolution display

Several dialogs in the Jedox Excel Add-in have been adjusted to display properly on high-resolution screens.

New Language: Persian

The Jedox Excel Add-in 7.1 now supports Persian.

 

Jedox Mobile

Automatic screen adaption

When opening a report, the report will automatically be resized to fit the current device’s width. The report can be zoomed using the “pinch” gesture.

Ad-Hoc reports synchronization

Ad-Hoc reports are now interchangeable amongst the different Jedox clients (Jedox Web, Jedox Excel Add-in, and Jedox Mobile), which means that users can now, for example, create an Ad-Hoc report in Jedox Mobile, open it in Jedox Web or Jedox Excel Add-in, make some changes there, and see those changes the next time they open this Ad-Hoc report in Jedox Mobile. All clients share the same data format for Ad-Hoc reports (i.e., Analyzer Reports in Jedox Web).

Redesigned login screen

Users get to their account with just one tap on the last account they have used. Creating or switching accounts is now more intuitive. OS-typical interactions are now included in the account selector (e.g., swipe to edit/delete accounts).

In-app navigation redesign

Instead of a hideable navigation menu on the left side, the main navigation is now positioned on the top of the screen and is always visible.

On Apple iPad, the navigation panel is shown in split view on the left side when using landscape mode.

Edit and filter dialogs in ad-hoc reports

Creating Ad-Hoc reports and editing their POV/filtering has been made easier and more intuitive.

Ability to select report groups and hierarchies

Instead of defining a single fixed report group to be used in the Mobile app, the app user can now select any existing group or hierarchy via a selector in the app header.

 

 

Setup

ATTN Breaking Change: 64-bit-only support for server components

The Windows Setup in 7.1 supports only 64-bit Windows versions for the installation of all server components. Only Jedox Excel Add-in, Office Add-in, and Sandbox are still supported on 32-bit Windows versions.

New Setup dialog box

The new Setup dialog box shows all the missing installations (VCRedist2013, VCRedist2015, Java, .Net). By clicking the “Next” button on this dialog, Setup will install these components and then continue. This box is displayed before the Final Options box and appears only if a patch is missing.

New Jedox Setup languages

The Jedox Setup 7.1 supports Korean, Persian, and Turkish as new languages.

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...