Rules functions

This section contains a complete list of all Planning Analytics rules functions. You can use any of these functions when writing rules.

Arithmetic operators in Planning Analytics rules
The following mathematical operators can be used when constructing rules.
Comparison operators in Planning Analytics rules
The comparison operators compare values in the formula portion of a rule calculation statement.
Logical operators in Planning Analytics rules
You can combine expressions in a rules calculation statement using logical operators.
Attribute rules functions
Rules functions that work on attributes.
Consolidation calculation rules functions
The ConsolidatedMax; ConsolidatedMin; ConsolidatedAvg; ConsolidatedCount; and Consolidated CountUnique perform mathematical calculations on consolidations.
Cube data rules functions
Rules functions that work on cube data.
Date and time rules functions
Rules functions that work with dates and time.
Dimension Information Rules Functions
Rules functions that manage dimension information.
Element Information Rules Functions
Rules functions that manage element information.
Financial Rules Functions
Rules functions used to manage financial information.
Hierarchy Rules Functions
Functions to manage hierarchies in rules.
Logical Rules Functions
Logical functions to use in rules.
Mathematical Rules Functions
Mathematical operators to use in rules.
Text Rules Functions
Rules to manage text in rules.
Miscellaneous Rules Functions
Rules functions not found in other categories.

Parent topic: References