Managing Rules

The Rule Editor features syntax editing of OLAP rules and rule templates, including optional auto-complete while typing. For details on rule syntax, see Business Rules Overview.

To display the All rules tab, select a cube and turn on the Rules button at the top right:

You can also right-click on the cube name in the navigation tree and select Edit rules... from the context menu. Both ways will show the All rules tab:

Here you can create, edit, import, export, and update rules.

To open a selected rule you can double-click on it or you can use the edit button.
The rule editor will open with following areas: Manual edit area, Comment, Query, and Rule editor with selection areas.

Last ones are descripted below:

  1. Dropdown list to define the scope of the rule: all elements, base elements, or consolidated elements.
  2. Dropdown list to select the rule form.
  3. Dropdown list to select the target dimension.
  4. Gear wheel icon to select an element or element list. If Element list is selected, the display of the inner element control changes. If you then open the Select Elements dialog, selection of multiple elements is possible. The elements will be added in several controls, with the matching rule syntax. To add another element to the same dimension list, click on a gear wheel:
  5. Dropdown list to select the rule content, including rule functions. You can use named Subsets in the Rule Editor.
  6. Gear wheel icon is used to set the rule type as expression or variable.
  7. Dropdown list shows possible source dimensions.
  8. Gear wheel icon is used to select an element or apply a function.
  9. The "three points" icon offers a selection of valid operators.
  10. Button to collapse all selection areas.
  11. Button to expand all selection areas.
  12. Button to refresh the selection areas.

To enable auto-completion when typing a rule formula, use the key combination CTRL + SPACE.

Changed and unsaved rules are indicated with a blue icon in front:

There will be no warning if you hide / quit the Rules tab(s) with unsaved changes, but the changes will be retained until you close your Jedox session. You will receive a warning for unsaved changes when you close your Jedox session:

Ordering

You can order dimensions and cubes in Rule Editor:

In places where only dimensions of a specific cube are shown, dimensions are listed by the order they have in the cube.

Updated February 7, 2025