Jedox Major Release 2025

Release Notes

We have reduced the number of major Jedox releases per year, and now reserve them for pivotal moments in our software's evolution. Major releases will mark milestones characterized by the introduction of substantial enhancements and innovations.

As with all previous Jedox Cloud deployments, we continue to deliver regular patches for current Jedox releases, including bug fixes, frictionless improvements, new features, as well as security and performance enhancements.

We continue to maintain support for versions released within the last 12 months. See Support Lifecycle for details.

Canvas

Charts on Canvas

The native charts component allows users to incorporate charts into their Canvas, providing an intuitive and interactive way to visualize data.

  • Drag and drop charts onto Canvas : Users can drag and drop charts components onto their Canvas, allowing for intuitive and flexible workspace customization.

  • Chart pop-up: When users drag and drop a chart onto their Canvas, a pop-up appears, allowing them to create and customize a new Bar or Line chart. Users can change the data source, define container setting (Canvas), type of chart, and chart configuration.

  • Chart frame: When users add a chart to their Canvas, a visible frame outlines the borders, making the chart's position clear.

  • Charts' interactivity: Charts on Canvas are interactive and dynamically respond to changes in other components. For example, if the data source is connected, charts will update in real time based on selections made in a Combobox.

Managing charts

Users can view Canvas chart properties in the Inspector after selecting the object in the Canvas. They have the flexibility to modify and manage Canvas charts according to their needs. They can easily edit existing charts to update data, adjust formatting, or refine visual elements. Additionally, if a chart is no longer needed, users can delete it to maintain a clean and organized workspace. These actions ensure that users have full control over their Canvas charts, allowing for efficient data visualization and customization.

  • Charts' Format tab: The Format tab of a chart in Canvas enables users to see and configure properties such as Name (ID), width, height, background color, radius, border, padding, and visibility.

  • Charts' Data tab : The 'Edit Chart' button in the Data tab of a chart enables users to modify, rearrange, and customize the data source for the chart to suit their needs.

  • Charts size in Canvas: The size of a chart within a Canvas does not need to be specified during design, and users can adjust its size at any time.

  • Right-click on Charts: Users can right-click on a chart in Canvas to access options such as cut, copy, paste, or delete.

  • Charts' default naming: When charts are added to the Canvas, they are automatically assigned sequential names, following a numeric pattern for easier identification. The first chart is named "Chart1," the second "Chart2," and so on, with each subsequent chart receiving an incremented identifier. Users can rename any charts through the Format tab.

  • Charts export: Users can export charts in PDF, PNG, JPG, or SVG formats, enabling easy sharing and integration across various dashboards.

  • Corporate branding theme: Users can create, manage, and apply chart themes within the Themes section of Jedox Web. The default theme features the Jedox Blue color palette and the Inter font, which can be applied to Canvas charts or replaced with custom themes.

Canvas usability improvements

  • Stored subsets in Canvas Dynatables : Users can now also use a stored subset as a source for a Dynatable dimension in Canvas, allowing them to easily apply a simple or complex combination of elements.

Dynatables

Data entry in Dynatables

Dynatables now support enhanced data entry capabilities, allowing users to interact with data more efficiently. Users with appropriate permissions can enter data directly into single cells, and the changes will be written back to the OLAP database.

  • Enable/disable data entry in global Dynatables: The Settings button, located next to Save in the Dynatable UI, allows users to configure data entry settings. Users with full access or D rights (sub-set view role object) can modify the write-back and splashing settings, while end users have limited access. Only global Dynatables with this feature enabled will display data entry cells. All other global Dynatables will function normally but without data entry indicators or the write-back capability.

  • Visual cues for editable and non-editable cells: Users with write access can easily distinguish between editable and non-editable cells. Editable cells are visually highlighted, indicating that users can enter values. This functionality is determined by user permissions and cell properties retrieved from the OLAP database.

  • Single-cell writeback: Users can enter data directly into a single cell and have it written back to the OLAP database. The Dynatable updates automatically upon data entry, eliminating the need for a separate save or submit action.

  • Enter splashing parameters in Dynatable cells: Users can input splashing parameters directly into cells using any of the available splashing commands. The entered values are processed and written back correctly based on the specified splashing command, ensuring accurate data distribution.

  • Type-based data entry: Users can input values according to the designated cell type, such as numeric, string, etc.

  • String Editor: Users can view and edit text in the String Editor. When an admin or a user with write permissions selects a string-type cell, a cell text editor opens, allowing text input and scrolling. If single-cell data entry is enabled, the input is written directly to the cube. This feature supports keyboard navigation (see next point).

  • Keyboard Accessibility for String Editor: Users can open the String Editor directly using keyboard shortcuts, allowing for quick and efficient access to textual data within a Dynatable. This feature enables reading and editing of text-based content without requiring a mouse, improving workflow speed and accessibility.

Usability and settings improvements

  • Tab key navigation: Users can now navigate smoothly between cells using the Tab and Shift + Tab keys. Pressing Tab moves the selection to the next cell, while Shift + Tab moves it to the previous one, enhancing efficiency in data entry and editing.

  • Dynatable Pivot and POV visibility settings: Administrators and Super Planners can now control user access to Dynatable Pivot and POV sections. Through the "Pivot and Configuration" section of the Dynatable's settings, they can manage the visibility of POVs and the Pivot, enable or disable POV selection, drill-down functionality, zero suppression, and expand/collapse operations.

Jedox Web

Themes

The Themes section in Jedox Administration allows users to create custom palettes and upload fonts to personalize their Canvas charts. Users can create and save up to three corporate brand themes. Existing themes can be viewed in Administration>Themes.

  • Themes fonts: Fonts can be uploaded by either dragging and dropping the font file or clicking Choose File.

  • Applying themes to charts: Users can apply custom-built themes to Canvas charts to ensure consistency in design and enhance visual appeal.

  • Palette and font limitations: Users can create up to three color palettes, each containing a maximum of eight colors. Users can also upload one custom font file at a time.

  • Editing and deleting themes: Users can modify their corporate brand palette Themes to ensure consistency with their latest branding guidelines. This allows them to update colors, styles, and other visual elements as needed, maintaining a cohesive brand identity across all platforms. They also have the ability to delete Themes that are no longer needed, ensuring their brand palette remains relevant and up to date.

  • Theme access levels: The access level for themes is determined by the ste_settings role right object in OLAP. The available access levels are: N: No access, R: Read-only, D[W]: Full access

Jedox Web usability improvements

  • Reconnection dialog: If the connection to Jedox Web is lost, a reconnection dialog will appear and remain active until the connection is restored. This dialog will continuously check for reconnection. Note that in the event of a server crash, users may be logged out automatically to prevent further errors.

  • Improved scrolling on spreadsheet: Spreadsheet scrolling on touchpads is now smoother and more responsive, enabling faster navigation through reports.

  • Increased the file upload limit in Jedox Web: The upload limit for databases, models, and other files has been increased from 2 MB to 2 GB.

  • Enhanced file upload dialogs in Jedox Web: The file upload dialogs in Jedox Web have been redesigned and standardized across the platform. They now include built-in validation for file type and size before uploading.

  • Enhanced read-ahead functionality: The read-ahead coefficient, which can be configured in the administration settings, has been enhanced to improve data loading performance. Previously, this feature primarily preloaded rows when scrolling downward. Now, it also preloads rows when scrolling upward, ensuring a smoother and more efficient navigation experience in large datasets.

PHP 8.3 for Spreadsheet Macros ready for testing

As announced in Deprecations and Breaking Changes, Cloud instances will automatically use PHP 8.3 in the next major release after 2025.1. Customers who want to try the new version can reach out to Jedox Support, but it should be noted that PHP 8.3 is considered experimental in Jedox 2025.1 and should be used with caution.

The list of breaking changes and backward incompatibilities can be found on the PHP website.

OLAP

Improved rule performance in multiparameter functions

Performance has been enhanced in rules using PALO.DATA or DCR where multiple source coordinates depend on a single target coordinate, e.g.,

PALO.DATA("","", !'Customer',PALO.DATA("","CustomerDetails",!'Customer',"Currency"))

Faster report calculations

OLAP now enables multi-core aggregation of previously cached base cells, resulting in faster rule calculations in reports.

Improved performance in Spreadsheet Server

Performance has been improved when switching between workbooks and tabs during a Jedox session.

Integrator

Ability to load JSON without root element

A new option "Skip root element" enables a JSON array to be generated without a root element in a JSON load.

Custom aggregation separator for group concatenation

You can now designate a custom separator (i.e., ", ; [] # XX!") when performing aggregation-type operations (table aggregation, table normalization, and table denormalization).

Groovy updated to 4

Jedox 2025.1 uses Groovy version 4, the current major version. Note that previous versions of Jedox have not been updated.

Updated components

In Jedox version 2025.1, the following components were updated:

Component Version
Apache 2.4.59
PHP (Apache) 8.1.22
PHP (SSS) 7.3.33
PHP (SVS) 8.3.3
OpenJDK 21.0.5

Updated April 23, 2025