General rules syntax

This section provides an overview of the syntax used in rules.

Note: The dimension rules are obsolete. If dimension rule elements still exist in the database, the respective dimension fails to load.

If you are affected, contact Infor Support.

General syntax

Rules have this general syntax:

[Target] = [Formula]

The target indicates an area of the cube, such as several 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 to this cell.

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

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

Comments

Rules can have comments. There are two formats:

The single line format is //
The multiple line format is /* */