In-Preview and Deprecated Features

image_pdfimage_print

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.

Feature description In preview version GA version
ComboBoxes support very large dimensions 2019.3  
Dynamic views – styles and formats 2019.3  
Using a view as a chart source 2019.3  
New shortcut for concatenation 2019.3  
Lightweight GPU 2019.2 2019.3
Stored subsets can be flagged as default 2019.2  
Stored views can be flagged as default 2019.2 2019.3
Storing dimensions in binary format 2019.1  
Disable saving CSV files for dimensions 2019.1  
Jedox Web Subset Editor can now be enabled in the Excel Add-in 2019.1 2019.2
Email notifications are configurable in the Scheduler templates 2019.1 2019.3
OLAP Server performance and log information 2018.4 2019.1
Optional timeout for In-Memory DB Server requests in client components 2018.4 2019.3
Calculation Profiler 2018.4  
Flexible cube layout with dynamic cell reference (DCR)  2018.3 2018.4
Optimization for database file storage 2018.2 2019.1
Batch export in PNG format 2018.2 2018.3
  
ComboBoxes support very large dimensions (in preview as of 2019.3)

ComboBoxes now support very large dimensions. When using the new option “Large Subset” in the ComboBox Properties dialog, the source data for the ComboBox is fetched on demand, as user expand, or search, in the ComboBox list.     

Dynamic views – styles and formats (in preview as of 2019.3)

You can define specific styles and cell properties for elements in a dimension. These styles are stored as attributes in the In-Memory DB. You can use these styles for reports with Jedox Views.     

Using a view as a chart source (in preview as of 2019.3)

With the new 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 (in preview as of 2019.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 but is not yet supported 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 (in preview as of 2019.2)

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. 

The new OLAP Calculation Profiler lets you inspect the details of specific value-calculation requests in the Jedox In-Memory DB. A history of requests per user session can be enabled in the new OLAP Visualization panel in the Performance area of Jedox Administration. Additionally, profiling can be enabled, in which case a visualization for long-running calculations in the request list can be generated, showing e.g. which rules were calculated and for how long. 

OLAP Calculation Profiler (in preview as of 2018.4)

The new OLAP Calculation Profiler lets you inspect the details of specific value-calculation requests in the Jedox In-Memory DB. A history of requests per user session can be enabled in the new OLAP Visualization panel in the Performance area of Jedox Administration. Additionally, profiling can be enabled, in which case a visualization for long-running calculations in the request list can be generated, showing e.g. which rules were calculated and for how long. 

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.

Flexible cube layout with dynamic cell reference (DCR)  (GA 2018.4)

As of 2018.3, it is possible to write rules with so-called dynamic cell reference, which shortens and simplifies the use of PALO.DATA and provides support for flexible cube layout. 

DCR requires a cube name to be specified in single quotes before square brackets. It can be empty to reference the “self” cube. This name specification is important to distinguish between old intracube cell references, which have many limitations and special STET representation ( STET() can be written as []). Each item MUST specify the source dimension name for the source cube in single quotes, followed by a colon and either the source element in single quotes or general string expression that evaluates an element name.  

 Benefits of DCR are: 

  • The dimension can be found automatically. It does not have to be specified. 
  • The default read element is used if a dimension is added to the source cube. 
  • The order of parameters is not important  

 For example, the rule below shows the syntax before Jedox 2018.3: 

 PALO.DATA(“”,”Sales”,!’Month’,!’Year’,!”Product”,!’Customer’,!’Region’,”Units”) 

 The same rule with 2018.3 syntax is much more efficient: 

 ‘Sales'[‘Measure’:’Units’] 

 Note: support for DCR in the Rule Editor is still pending. 

 

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 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
Tool bar options “Toolbar” and “Ribbon” 2019.2 2019.4
Excel Add-in native dialogs
2019.2  
Import Wizard in Excel Add-in
2019.2  
Native Excel SVS editor
2019.2  
GPU Advisor as native dialog in Excel Add-in
2019.2  
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 2019.3
Function Type Java 2019.1 2019.2

ODBO/MDX component

2018.4  
MaxDB connection 2018.4 2019.2
 
image_pdfimage_print