Platform 2024.1 Release Notes

AI in Jedox

New AI-powered Jedox Help Center

Now generally available to users, the new Jedox Help Center relies on an advanced AI Search engine able to engage in natural language conversations, sifting through the Knowledge Base to provide simple step-by-step instructions to solve your questions and technical issues in no time.

Some of the AI Jedox Help Center advantages are:

  • Natural language understanding: being able to ask questions in human-like language makes the search process easier, quicker, and more focused.
  • Step-by-step guidance: tasks like mastering new features or troubleshooting take a shorter time and less effort.
  • Personalized answers: the assistant learns from previous interactions and starts tailoring responses according to the user.
  • Digital accessibility: text-based interactions offer easier navigation than other interfaces.

An important note before diving into the new Jedox Help Center is that the AI Search uses ChatGPT to generate results. Therefore, discretion and discernment are essential. Don't share confidential information. Also bear in mind that, although the search engine will improve over time, it can still generate incorrect responses and unreliable content. You can always resort to the Jedox Knowledge Base to confirm the validity of the information.

Improved alert mechanism in AIssisted™ Data Preparation Wizard

The Data Preparation Wizard was upgraded with more meaningful warnings and guidance for trend and seasonality functions.

User guide enhancement in AIssisted™ Classification Wizard

Introduction of a comprehensive walkthrough video in the Classification Wizard results page, guiding users through detailed result analysis.

Performance optimization in AIssisted™ Time Series Wizard

The Time Series Prediction ETL was updated to make outlier service work with enhanced performance when excluding zeros for Python services.

Enhanced reporting functionality in AIssisted™ Time Series and Driver-Based Prediction Wizards

This update introduces refined result reports, offering better insights and streamlined visualization capabilities within both Time Series and Driver-Based Prediction Wizards.

NLP in Views (in preview)

The AI assistant enables users to access and explore data in Jedox Views using natural language, thus accelerating the transition from question to insight. The simplified data query process makes it easier for controllers to perform ad-hoc analysis and reporting. This feature is still in preview.

Views

Jedox Views

Jedox Views enable you to access In-Memory DB Views directly within Jedox Web UI (independently of Jedox Web Spreadsheets). The Views UI is integrated into the top-level navigation of Jedox Web, alongside sections like Reports, Designer, and Modeler.

Opening existing Views

When users click on the Views in the navigation bar, they can see a comprehensive list of all the stored Views, open the Views, and explore them

Creating new Views

Users who have the minimum access rights of "W" for the "sub-set view" can create views in the new Views section.

Modifying Jedox Views

To alter the presentation of your report, users can use "Pivot". They can drag and drop dimensions into their Views sections or interchange the dimensions displayed in the Point of View (POV), Rows, and Columns.

Saving Views

Once a View is customized, users can save it for later use. Moreover, when they require similar Views with slight variations, they can utilize the "Save as" function to duplicate and save their View under a distinct name or ID.

Web

Improved session handling

The default session timeout has been significantly increased to 60 minutes. When sessions expire, the user will now be redirected to the login page, rather than receiving error messages and generic errors.

Canvas

Result string in the Edit expression dialog

The result string in the “Edit expression” pop-up dialog of Canvas is now truncated to 150 characters and shows an ellipsis “…” once the limit is reached.

Integrator

Google Sheets integration

Jedox now offers seamless integration to Google Sheets with a dedicated connector, extract, and load.

Export and import multiple Integrator projects

Multiple projects can be selected in the Import/Export dialog. Files can be dragged into the dialog or selected from an explorer window.

New option for case-insensitive sorting

Elements can now be sorted without regard to case in TableView and TreeView transforms, and RelationalTable and CosmosSQL extracts. These options appear as “ascendingCaseInsensitive” and descendingCaseInsensitive”.

The other sorting options (“asc” and “desc”) have been renamed “ascending” and “descending”.

Connections to Sharepoint locations now support oauth2RefreshToken

Jedox now supports two token authentication methods for OAuthToken connections to Sharepoint locations: oauth2PasswordCredential and, as of 24.1, oauth2RefreshToken.

Improved UI performance when opening Integrator projects

Integrator UI now loads resources only when they are needed, improving initial loading times of projects.

Updated components

In Jedox version 2024.1, the following components were updated:

Component Version
Apache 2.4.57
PHP (Apache) 8.1.22
PHP (SSS) 7.3.30
PHP (SVS) 8.1.16
OpenJDK 17.0.9

Updated March 27, 2024