Jump to Deprecated Features
In-Preview Features
Some Jedox features are released IN PREVIEW. These features have undergone testing and 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. Our intention is to get your feedback on these features before making them GA and production-ready. These in-preview features may undergo minor design changes while going through the maturation process. Most in-preview features can be enabled in Jedox Web Administration.
The following features have been or currently are in preview. If the feature has become generally available (GA), we noted the version in which it became GA.
Elements grid in Modeler optimized for large dimensions
Performance of large, highly nested dimensions in Modeler has been optimized with this in-preview feature. Once turned on (with rollout feature Modeler optimization), large dimensions expand much more quickly.
PHP 7 in PHP Macro Engine
The PHP Macro Engine in Jedox Spreadsheet Server can now optionally use PHP version 7. Note that usage of the PHP 5 engine will be deprecated as of version 2021.2 and removed in a future version.
Paste Elements as embed dialog
The Paste Elements dialog is now available as a Web dialog, with the same set of features available in Jedox Web. To use this feature, "Enable Preview Features" and "Use Web dialogs" must be set in the Excel Add-in Options dialog.
Back-end changes to PostgresSQL in Drillthrough for Cloud customers
In Cube loads with "Persisted" mode activated in Drillthrough, the internal storage required for the procedure will move to a dedicated PostgresSQL service to improve reliability, performance, and scalability. The migration will occur starting with 2021.1 for select Jedox Cloud customers. No adaptations will be required in Integrator projects.
Subsets stored with View XML schema
When set, the Subset Editor will store subsets using the View XML schema rather than the legacy Subset XML schema. The View XML schema offers several advantages; for example, the stored subset remains stable when attributes are re-created while using Afilter.
An optional configuration for the In-Memory DB can automatically convert stored subsets in OLAP to the new XML schema on database load.
This feature is in preview and must be activated with the rollout feature Subset viewxml.
Web dialog for Paste View in Excel
The Paste View dialog is now available as a Web dialog, with the full set of features available in Jedox Web. To use this feature, "Enable Preview Features" AND "Use Web dialogs" must be set in the Excel Add-in Options dialog.
Improvements to stored subsets in Jedox Views (in preview as of 2020.3)
- A stored subset for which an alias was defined will automatically be shown with that alias in the View.
- If the subset defines the "Parents below children" option, then expansion of elements in the View will expand parents below children, without having to explicitly enable it in the View.
- Sorting of the stored subset is automatically applied in the View.
- The alias used in the subset can be overridden locally in a specific View.
As a result of these changes the option "Enforce stored subset definition" has been removed from the Select Elements dialog.
Using a view as a chart source (GA 2020.2)
With the PALO.VIEW.TABLE() formula, you can use the data from a stored view directly as source for a chart in Jedox Web, without retrieving the data in the spreadsheet first.
New shortcut for concatenation (GA 2020.3)
The pipe operator ( | ) can now be used for concatenation in rule functions. For example, instead of CONCATENATE(“Value 1”, “Value2”), you could use “Value 1” | “Value 2”. This shortcut can be used when editing rule definitions in the rule list as well as in the Advanced Rule Editor.
Lightweight GPU (GA 2019.3)
The internal architecture of the GPU Accelerator has been redesigned for more efficient memory usage. Calculations on cubes converted to GPU now use the same storage structure as CPU calculations, which also greatly improves the speed of converting a cube to GPU.
Although in preview, this feature is fully usable, and no manual migration steps are required. Note that the configuration options gpu-data-storage and gpu-dim-order for the In-Memory DB are now obsolete.
Stored subsets can be flagged as default (GA as of 2019.4)
A stored subset can now be flagged as the default for a dimension in both the Subset Editor and Select Elements dialogs. When opening either dialog on new ComboBoxes, DynaRanges, etc., the dialog checks for the existence of a flagged default subset and if found, selects it.
Stored views can be flagged as default (in preview as of 2019.3)
You can now flag a stored view as default from the Cubes section in the Modeler.
Jedox Web Subset Editor can now be enabled in the Excel Add-in (GA 2019.2)
You can enable Jedox Excel Add-in to paste a subset from Jedox Web. To do this, you must set a DWORD 32 registry key in the Registry Editor.
Email notification are configurable in the Scheduler templates (GA 2019.3)
You cannot configure the text of the email notification sent by the Scheduler with the help of the variable text blocks You can create and store various templates for mail texts.
OLAP Server performance and log information (GA 2019.1)
As announced in 2018.3, the OLAP Server can now log certain information regarding performance and resource usage into a dedicated log backend, using the syslog protocol. New configuration options have been introduced for the facility and specific verbosity. The timestamps of the messages are now sent to the syslog.
Optional timeout for In-Memory DB Server requests in client components (GA 2019.3)
A timeout period can now be set for In-Memory DB Server requests in client components. If the defined timeout is reached while the client is waiting for In-Memory DB Server to finish a running request, the client will close the connection. By default, the timeout is not configured in any component.
Storing dimensions in binary format (in preview as of 2018.4)
Dimensions can now be saved in binary format, which speeds up load performance. This feature can be enabled in palo.ini by setting the value of the key dimension-file-format to binary. Note that databases containing dimensions stored in binary format are not portable between Linux and Windows.
Disable saving CSV files for dimensions (in preview as of 2018.4)
Reduces time needed for saving dimension files by saving them as .bin rather than .csv. This feature can be enabled in the palo.ini with the key no-csv-save-dim.
Optimization for database file storage (GA 2019.1)
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.
Batch export in PNG format (GA 2018.3)
Besides export of report in PDF and XLSX format, it's now also possible to create tasks that will export the report in the PNG image format
Deprecated Features
The following features have been or will be deprecated. Below we note the version in which deprecation was announced, and, if applicable, the version in which it no longer appears.
| Deprecated feature | Deprecation announced |
Deprecated |
| SOAP API | 2021.1 | |
| PHP 5 in Macro Engine | 2021.1 | |
| Analyzer reports in Jedox Web | 2020.1 | 2020.3 |
| Native dialogs in Excel Add-in: Subset Editor, Data-Driven Modeling, SVS Editor, Import Wizard | 2020.1 | |
| "Toolbar" option | 2019.2 | 2020.1 |
| Data-Driven Modeling in Excel Add-in (replaced by Web dialog) |
2019.2 | 2020.1 |
| Import Wizard in Excel Add-in (replaced by Web dialog) |
2019.2 | 2020.1 |
| SVS Editor in Excel Add-in (replaced by Web dialog) |
2019.2 | 2020.1 |
| GPU Advisor as native dialog in Excel Add-in |
2019.2 | 2019.4 |
| Linux setup: “–no-deps” deprecated for start script |
2019.2 | 2019.2 |
| FieldTransform function of type Java | 2019.1 | 2019.2 |
| Changing Passwords with the direct cell writeback | 2019.1 | 2019.2 |
| Connection type JedoxXMLA | 2019.1 | 2020.1 |
| Function Type Java | 2019.1 | 2019.2 |
| ODBO/MDX component | 2018.4 | 2020.1 |
| MaxDB connection | 2018.4 | 2020.1 |
Updated April 6, 2021