General cube rules syntax

This section only covers the cube rules. Dimension rules still work for compatibility reasons, but should not be created anymore. Dimension rules are internally used in the same way as cube rules.

Cube rules have this general syntax:

[Target] = [Formula]

The target indicates an area of the cube, such as a number of specific cells, to which the calculation applies. The formula then defines the calculation.

In this example, the left-hand portion of the rule is the target and the right-hand portion is the formula:

[PROFIT:'Price per Unit'] = [PROFIT:'Revenue'] / [PROFIT:'Sales Volume']

Multiple cube rules can target a certain cell. If this is the case, then only the first cube rule applies.

You can define the type of affected cells for the rule in the formula. The types are all, consolidated (C), and base (B). If you do not specify a type, all cells will be affected for the calculation. Specify B for only base cells. Specify C for only consolidated cells.

The Rules Parser ignores spaces and line breaks. You can insert spaces and line breaks as necessary to make a rule easier to read and understand.