Dimension Extract


A dimension can be extracted from a Jedox In-Memory DB (OLAP) database using the dimension extract. The extract creates a tree.

Dimensions can be filtered for the following items:

  • Elements
  • Consolidations (i.e., hierarchical relations between elements)
  • Consolidation factors
  • Element types (numeric/string)
  • Attributes
  • Formats and styles for dimension elements
Main settings
Connection Connection to Jedox In-Memory DB
Dimension A dimension from the selected database
Read attributes
none No attributes are extracted.
standardAttributes Attributes are extracted. If several languages are defined in the database, only values of the default language are extracted.
includeLanguages Attributes are extracted for all languages of the database. The attribute names in the dimension extract are in the form “<attributeName>@<languageName>” (e.g. “Description@de_DE”)
Same as standardAttributes, but including formats and styles of dimension elements
Same as includeLanguages, but including formats and styles of dimension
Query Filter on Dimensions

A query filter on the dimension allows filtering according to the name of elements and the hierarchy. The values are filled dynamically, depending on the selected filter type (1), operator (2), and mode (3). These filtering options are described below.

1. Filter type options


All nodes that fulfill the filter criteria are included in the selection.


All nodes that fulfill the filter criteria are excluded from the selection.

2. Operator options


Filtering occurs according to the element specified. This operator is not case-sensitive. Example: Austria


Alphanumerical values in a particular range are filtered. Example: [A100,D200]


Numerical values in a particular range are filtered. Example: [1000,2000]


Empty values (blank, space, or multiple space values) are filtered. The Value field should be left blank.


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:


Filters the dimension elements according to a global subset for the dimension. The extract can filter a subset for one or more specific attribute values or a variable.

Filtering for a single attribute value

Filtering for a single attribute value can be done directly in the dimension extract. In the screenshot below, the extract uses a subset with a specific attribute as a dimension filter. It filters the subset “myVariable” for the attribute “SalesPerson” with the value “Shu”.

Filtering for multiple attributes

To filter for more than one attribute, you must first create a subset with the desired attributes in the Modeler.

Subset Editor in Designer filtering for multiple attributes

Then, in the dimension extract, edit the subset filter. At the Edit dialog, select the subset from the dropdown menu:

Filtering with an Integrator variable

The expression below uses an Integrator variable (“Value”) for the name value of the attribute:

The attribute filter is provided in the variable. The attribute filter from the subset and the attribute value is separated by a comma. In the screenshot below, the attribute is “SalesPerson” and the value is “Shu”.



3. Mode options

Defines a hierarchical filter for the dimension. If not set the default mode “onlyNodes” is applied which returns 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

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.


Selected value: Basic Sports Equipment

Only consolidated elements above the selected element are filtered.


Selected value: Austria

All bases under this value are filtered, including the parent element.


Selected value: Austria

Only the bases are filtered based on the element selected.

onlyNodes Only the selected element is filtered (nodal point).


Selected value: Austria

Only the element from the highest level of the hierarchy is filtered based on the selected element.


Example of Query Filter on Dimensions:

Filter Type