Rule Editor


To access the Rule Editor, you must select a cube and click on the Rules tab in the cube properties tab bar. Here you can create a new rule or edit an existing one.

Opening the Rules Editor in the cube properties tab

You can also edit an existing cube by right-clicking on the cube name in the navigation tree and selecting Edit rules… from the context menu:

Cube context menu with Edit rules… option

The Jedox Rule Editor allows UI-driven creation and editing of OLAP rules and rule templates.

The selection areas are described below, indicated by the numbers in the screenshot above.

  1. List box to define the elements that the rule applies to. Options are All Elements, Base Elements, and Consolidated Elements.
  2. List box to select the rule form. In Jedox 7.1, only Classic form is possible.
  3. List box to select the target dimension.
  4. Gear wheel icon to select element(s):

    If “Element list” is selected, the display of the inner element control changes. If you then open the “Select Element“ dialog, selection of multiple elements is possible. The elements will be added in several controls, with the matching rule syntax. Furthermore you can select “Add” with a gear wheel in the gray list to add another element to the same dimension list:
  5. List box to select the rule content, e.g. classic rule, marker rule, or function:
  6. Gear wheel icon is used to select expression or variable for the rule type:
  7. List box shows possible source dimensions.
  8. Gear wheel icon is used to select an element or a function:
  9. The “three points” icon offers a selection of operators:

Rule formula tree is collapsed by default

The formula tree of the source in the Advanced Rule Editor is collapsed by default from the second level onwards. With the buttons (1) and (2) you can collapse or expand all source lines.

Additionally, users can now control whether the Advanced Rule Editor panel should be collapsed or expanded by default, via right button click (3) on the Rule Editor panel label.

Other Editing Features

The Rule Editor features syntax editing, as shown in the screenshot below.

You can also enable auto-completion when typing a rule formula. To activate this feature, type the key combination CTRL + SPACE

Learn more about the Rule Editor in a free online course from Jedox Academy! Just enter your email address when prompted, and the video will begin playing.