Business Rules Overview

Jedox Business Rules enable you to execute complex calculations (division/multiplication, logical and various functions) for Jedox databases. These calculations can be executed for data cubes and for the following system cubes:

#_GROUP_CUBE_DATA
#_USER_GROUP
#_ROLE_RIGHT_OBJECT
#_USER_USER_PROPERTIES
#_GROUP_GROUP_PROPERTIES.

Getting startedThe general syntax of rules is [Target] = f[Source], i.e., [Target] is a function of [Source].

[Target] is the area in the cube that is to be calculated using rules. This target area is defined by dimension elements. Elements are not to be listed, if a rule is to apply to all dimension elements. Rules are mapped out per cube.

If a target area is defined in a rule, subsequent rules that describe the same or an overlapping target area are no longer effective. This means that specific rules have to be stored before general rules. The only exception is the rule function CONTINUE, which can switch from one rule into another rule defined on overlapping target areas.

Rules can be constructed in the Managing Rules in the Jedox Modeler; see also Supported Functions for Rules

Next Step: Business Rules Terminology and Operators

Check out the other important information on Rules

Business Rules Terminology and Operators

This article explains key terminology used in Jedox Business Rules and describes the operators available in the Rule Editor.

Comments, Formatting, and Restrictions

This article covers how to use comments and formatting in rules, and explains how cell type restrictions can be applied to limit rule calculations to base cells or consolidated cells.

Dimensions, Rule Targets, and Empty strings

This article explains how dimensions and rule targets are handled in Jedox Business Rules.

Cell References, Dynamic References, and OFFSET Functions

This article explains the different ways cells can be referenced in Jedox Business Rules.

Updated March 9, 2026