Jedox Web
New Canvas report type
Jedox Canvas allows users to compose flexible, responsive, and fast visualizations consisting of existing Jedox objects. These objects can be dragged and dropped onto the Canvas, which is flexible enough to resolve to any screen resolution or size.
Jedox Canvas reports are now available as a distinct report type, rather than a sheet within a Web Spreadsheet. Users can build a Canvas report using content from one or more Web Spreadsheet reports. When selecting sources for Canvas content, users will only be presented with files suitable for use with Canvas, so they can find what they need quickly and be confident that their selection is appropriate.
Canvas reports can be easily identified by the Canvas icon:
New ways to create a Canvas
Jedox 2022.4 offers two new ways to create a new Canvas report:
- Context menu in Designer
- Toolbar dropdown menu
Spreadsheet Advisor for Jedox Web Spreadsheets
The spreadsheet Adviser conducts several checks and then advises the user on optimal configuration settings. The result is a structured list of potential issues that affect performance.
For example, when building Web Spreadsheets, small changes like using PALO.DATAC instead of PALO.DATA can make a big impact on the performance of the report. The spreadsheet Advisor can help in identifying such issues and suggest solutions.
New Action: Send email
You can now send an email to inform people about workflow changes or other collaborative topics as part of an Action. The new "Send email" Action uses email settings defined in Administration->Settings and makes it possible to include multiple attachments, add CC or BCC recipients, as well as letting an end user write a custom email subject or body.
New Chart type: Heatmap
Jedox now offers Heatmap charts, which are commonly used to show relationships between two variables is a highly visual way. A Heatmap displays a two-dimensional tabular view of data, with each cell colored depending on the magnitude of the measure displayed. For example, Heatmaps allow users to visualize hot spots within data sets, and to show patterns and correlations.
SVG support in Web Spreadsheets
You can now place .svg files into your Web Spreadsheet with "Insert Picture".
Alphabetical ordering of project variables in Integrator Action
variables in an Integrator Action are now sorted alphabetically, so that it's easier to manage and define variable values.
Prevention of HTML rendering and JavaScript execution in Web Reports
Web Spreadsheets created in Jedox 2022.4 will automatically disable the rendering of HTML cell contents on a workbook level, so that HTML code in a spreadsheet cell is presented as string instead of HTML. This setting can be overwritten on a more detailed level through cell formatting. In cells where a standard function such as HYPERLINK() or SHOWPICT() is entered, HTML rendering is automatically enabled for that cell.
Jedox Cloud
VPN connections can be reused with different instances
All instances within an organization can now share the same VPN connection, so that the System Administrator only has to configure the VPN connection once.
New directory in SFTP for uploading PHP macro files
Anew directory has been added to the SFTP connection that allows Model builders to upload existing macro files. This is especially helpful when migrating from an on-prem instance with existing macro files.
Office Integration
Credentials storage for SAML connection in Excel
User credentials are now stored in the Excel cache memory, allowing returning users to select them from the respective fields instead of manually typing them.
Option to disable username / password authentication when NOSSO is disallowed on the Jedox Server
This option limits users to the authentication method defined by the administrator. This feature is currently available for Jedox Web and Jedox Mobile App.
In-Memory DB (OLAP)
Update Number of Target Cells in Planning Assistant more dynamically
The Planning Assistant now updates the estimated number of affected target cells much more intuitively. When entering a value, the number is automatically updated after the user has not typed anything for ~0.5 seconds.
Improved performance for large, fragmented dimensions
Large, fragmented dimensions now perform better in Jedox, particularly when working with a dimension in which elements are added and removed constantly (e.g. nightly Integrator job) over months or even years, which would lead to its fragmented state.
Auditing of attribute, system, and rights cubes
Attribute cubes, system cubes, and rights cubes can now be tracked by activating Audit on the cubes. These cubes and their logged changes can now be found in the Audit screen like any other cube.
Audit option on palo_setdata_bulk api function
Writeback operations done via PALO.SETDATA_BULK are now part of the audit trail, if audit is enabled for a cube. It will appear in the Audit screen like any manual writeback, with additional information to identify the bulk.
Confirmation prompt for stopping audit
When disabling an audit, there is now a confirmation prompt to inform users that associated data will be deleted, thus preventing unintentional loss of audit data.
Enable Audit logging option for 14 days
We enhanced the range of possible audit options with the option "14 days", so that you can choose any number out of 1, 7, 14, 30, or 365 days of audit trail.
"Safety net" for splashing
Jedox now includes a "safety net" for splashing that prevents users from over-populating a cube. When a user tries splashing on an empty slice where the number of affected base cells exceeds a given threshold, the Planning Assistant will open and suggest "Like" splashing, which typically reduces performance impact significantly.
The cell threshold can be set with a new configuration option ("splash-threshold") and has a default value of 1,000,000.
Integrator
New overviews of components & additional toolbar options in Integrator
The navigation in Integrator is now much more intuitive and enhances the functionality of breadcrumbs by bringing the capabilities that were previously only available in the tree view context menu to the toolbar. New component overviews show relevant information over all components of a certain type (e.g. all transforms). Additionally, existing functionality now appears in the component toolbar, so that actions such as copying a component to another project or managing Tracepoints are easily accessible.
New load type: JDS (Jedox Database Script)
Integrator can now create a database script from an existing database, as well as run an existing database script in the Jedox environment. There is a new JDSFile connection and JDS load in Integrator.
Include Lists in Jedox Database Scripts created via Integrator Scripting API
It is possible to create a Jedox database script with the methods of the Integrator Scripting API. The respective methods have been extended to include Lists in the generated Jedox database script, and are now aligned with the options provided in the Modeler UI.
OAuth 2.0 Token Authentication for Azure Blob files
OAuth 2.0 Token connections can now be used in file-based connections to Azure Blob Storage, which makes authenticating against Azure much easier and more central.
Active Directory Password Authentication for MS SQL connection
The Azure authentication method "Active Directory Password" is now supported for MS SQL connections (when used to connect to an Azure SQL database). A user / password combination of the Active Directory can be used to authenticate against the Azure SQL database. See MS SQLServer Connection for details.
Null can be used as default value in Lookup function
The Lookup function is now capable of returning null when no match can be found, by entering #null as static default value.
SFTP location for file-based connections
SFTP is a common and future-proof file protocol. From now on, data integrators can make use of this protocol in relevant Integrator connection components. All file-based connections (file, Excel, XML, JSON, directory) now offer SFTP as a location.
The new location type supports public-private key pairs as well as user / password / fingerprint authentication.
Files and folders can be zipped with FileAPI
A new FileAPI scripting method can compress files and folders to a .zip file in FileSystem locations, enabling data integrators to zip files that have been previously created via Integrator.
Aggregation function "selectivity" removed ATTN
The transform aggregation function "selectivity" has been removed, as announced in version 2022.3. For existing transforms that use this function, a different aggregation function must be selected.
H2 Integrator connection removed ATTN
H2 database connections will no longer be present in environments running Jedox 2022.4 or later, as announced in version 2022.2. We recommend to move your data to an alternative relational database such as SQLite, before updating to version 2022.4.
SOAP API removed ATTN
The Integrator SOAP API has been removed, as announced in version 2021.1. Use the Integrator Action where possible, or replace existing code with the Integrator wrapper. Note that the SOAP (WDSL) connection in Integrator to connect to external web services remains functional.
Setup & Configuration
Jedox SDK removed
Jedox Software Development Kit (SDK) has been removed, as announced with the 2022.1 release.
Technical Health
Updated components
In Jedox version 2022.4, the following components were updated:
| Component | Version |
| Apache | 2.4.54> |
| PHP (Apache) | 7.4.33 |
| PHP (SVS/SSS) | 7.3.30 |
| Tomcat | 9.0.68 |
| OpenJDK | 17.0.5> |