Cube data rules functions

Rules functions that work on cube data.

CellValueN
CellValueN returns the numeric value of the specified elements in a cube. This function is valid only in rules. Use of this function in a TurboIntegrator process will result in an error. Use of this function in a TurboIntegrator process will result in an error.
CellValueS
CellValueS returns the string value of the specified element(s) in a cube. This function is valid only in rules. Use of this function in a TurboIntegrator process will result in an error.
DB
DB returns a value from a cube in a Planning Analytics database. DB returns a numeric value if used in a numeric expression and a string value if used in a string expression.
ISLEAF
ISLEAF returns 1 if a specified cell is a leaf cell (identified solely by leaf/simple elements). If the specified cell is identified by any consolidated elements, the function returns 0.
ISUNDEFINEDCELLVALUE
ISUNDEFINEDCELLVALUE compares the passed value to the default numeric cube value, which is influenced by the presence of the UNDEFVALS declaration in that cube's rule. The function returns 1 if the passed value equals the cube's default value, otherwise the function returns 0.
UNDEF
UNDEF returns the undefined value. This function can be used to prevent data from being stored in a cube based on a logical test.
UNDEFINEDCELLVALUE
UNDEFINEDCELLVALUE returns the default numeric cube value, which is influenced by the presence of the UNDEFVALS declaration in that cube's rule.
UNDEFVALS
Putting UNDEFVALS in the rules for a cube changes the default value for the cube from zero to a special undefined value. Like other rules functions, UNDEFVALS applies only to the cube associated with the rule in which the function appears.

Parent topic: Rules functions