Cube Delta Extract

This extract pulls only the new or changed data since the data was last extracted. It creates an OLAP extract of the changes done between two time periods (i.e., a Delta).

This feature is Early Access and available upon request only. Contact your Jedox sales rep for details.

Main settings

Connection

Connection name

Query cube

Name of the cube to extract; available cubes will appear in the dropdown list.

Read rule-based values

If set, all rule-based cell values are extracted. Empty cell values are not extracted. In case of zero values:

If "empty cells" is set to "excludeEmpty", then the zero value is copied.
If "empty cells" is set to "excludeEmptyAndZero", then the zero value is NOT copied.

Query filter on dimensions

A query filter on the dimension allows filtering according to specified elements or values. The filter type can be set to "accept" or "deny" as required. This type of filter allows particular cube areas and / or cube cells to be filtered out. Only cube cells that meet the filter conditions for all dimensions are extracted.

Text and numeric values can be filtered.

Note: "Equal" is case-insensitive, while "Like" is case-sensitive. You can change the case-sensitivity by using a (?) modifier. Seehttps://www.regular-expressions.info/modifiers.html

Operator

Comparison operators can be used on element names.

equal The element entered here will be filtered. Filter behavior depends on the type of data:
String: the filter must be exactly equal to the source value.
Decimal number (floating or double): the filter value must be the most minimal representation of the value. For example, if the source value is 1.0, the filter value must be 1. If the source value is 1.5000, then the filter value must be 1.5.
Non-decimal number (int or long): the filter value must be exactly the same as the number.
Boolean (true/false): the filter must be "true" or "false" as appropriate.

inAlpharange Alphanumerical values in a particular range are filtered. Example: [A100,D200]. The short GIF below shows how this functionality works with dates.

inRange Numerical values in a particular range are filtered. Example: [1000,2000]
Other examples:
“[100,200]” - inclusive range: 100, 101.....199, 200
“(100,200)” - exclusive range: 101, 102, ... 198, 199
“[100,]” - inclusive half-open interval: numbers greater or equal to 100
“[,100)” - exclusive half-open interval: numbers lower than 100

isEmpty Empty values (blank, space, or multiple space values). For this operator, the Value field should be left blank.

like Filters the dimension elements according to regular expressions. This operator is case-sensitive. You can change that by using the (?i) modifier at the start of a regular expression.
After using the regular expression, the data preview must look like in the example below:

subset Filters the dimension elements based on any stored global Subsets for the dimension. The extract can filter from Subsets with one or more defined filter criteria or variables:
Filtering from a stored Subset
Select the stored Subset from the "Edit Subset" dialog:
If the Subset uses variables, you must select them manually by adding as many rows as there are defined variables within the "Edit Subset" dialog.
Filtering with an Integrator variable
For more dynamic design, you can replace the value of the Subset variable with an Integrator variable, as shown in the screenshot below:
Note: the value " has to be escaped as \"

Mode

Defines a hierarchical filter for the dimension. If not set, the default mode "onlyNodes" is applied, returning only the filtered elements independently of the hierarchy. In case of a global Subset filter, a mode is in general not reasonable.

Mode	Example	Tree view
rootToBases	Selected value: Austria Based on the selected element, this element and the elements above and below are filtered.
rootToNodes (to top element and the nodes above)	Selected value: Basic Sports Equipment All parents and their respective parents are filtered, including the selected elements.
rootToConsolidates	Selected value: Basic Sports Equipment Only consolidated elements above the selected element are filtered.
nodesToBases	Selected value: Austria All bases under this value are filtered, including the parent element.
onlyChildren	Selected value: East Only the children are filtered based on the element selected.
onlyBases	Selected value: East After filtering the elements according to any of the operators, takes all base elements underneath them. Consolidated elements are not included. From the cube, only cells where ALL elements are base elements are returned. If you would filter all dimensions with mode "onlyBases" setting, "Base elements only" has no longer an effect. But here it removes cells from the result that are on consolidated elements for other dimensions. In the example on the right, the filter value "East" passes the operator, and the returned elements are the base elements.
onlyNodes	Only the selected element is filtered (nodal point).
onlyRoots	Selected value: Austria Only the element from the highest level of the hierarchy is filtered based on the selected element.

Cube output columns

The cube output columns of the extract can be specified by defining for each column:

The name of the column (default: Name of the dimension)
The cube dimension

In most cases this manual definition is not necessary: by default, all cube dimensions are output columns of the Cube extract with the dimension name as column name and with the order as defined in the cube.

The manual definition offers the options of

reordering columns
renaming columns
omitting some of the cube dimensions

When a cube dimension is omitted from the output columns, the cube values are extracted on the default read element of this dimension. This default read element has to be specified for the dimension in the Modeler. Additionally, no filter condition can be applied on this dimension.

Extract mode

Previous delta, recalculate,

Use caching

If caching is activated, the complete output of the extract is temporarily stored during the first call of the extract, using an internal H2 database. Subsequent calls of the extract read directly from the cache without connecting to the underlying source system of the extract. If the extract or the underlying connection contains variables, a separate cache is build for different values of these variables.

See Caching in Extracts and Transforms for more information.

Advanced settings

Rename value: name of the last column containing the cube cell value.

Updated April 30, 2026

equal	The element entered here will be filtered. Filter behavior depends on the type of data: String: the filter must be exactly equal to the source value. Decimal number (floating or double): the filter value must be the most minimal representation of the value. For example, if the source value is 1.0, the filter value must be 1. If the source value is 1.5000, then the filter value must be 1.5. Non-decimal number (int or long): the filter value must be exactly the same as the number. Boolean (true/false): the filter must be "true" or "false" as appropriate.
inAlpharange	Alphanumerical values in a particular range are filtered. Example: [A100,D200]. The short GIF below shows how this functionality works with dates.
inRange	Numerical values in a particular range are filtered. Example: [1000,2000] Other examples: “[100,200]” - inclusive range: 100, 101.....199, 200 “(100,200)” - exclusive range: 101, 102, ... 198, 199 “[100,]” - inclusive half-open interval: numbers greater or equal to 100 “[,100)” - exclusive half-open interval: numbers lower than 100
isEmpty	Empty values (blank, space, or multiple space values). For this operator, the Value field should be left blank.
like	Filters the dimension elements according to regular expressions. This operator is case-sensitive. You can change that by using the (?i) modifier at the start of a regular expression. After using the regular expression, the data preview must look like in the example below:
subset	Filters the dimension elements based on any stored global Subsets for the dimension. The extract can filter from Subsets with one or more defined filter criteria or variables: Filtering from a stored Subset Select the stored Subset from the "Edit Subset" dialog: If the Subset uses variables, you must select them manually by adding as many rows as there are defined variables within the "Edit Subset" dialog. Filtering with an Integrator variable For more dynamic design, you can replace the value of the Subset variable with an Integrator variable, as shown in the screenshot below: Note: the value `"` has to be escaped as `\"`