IGNORECONSTANTS

This Essbase configuration setting controls whether #Missing values, when used as operands in formulas, should remain #Missing after the formula calculation.

Syntax

IGNORECONSTANTS TRUE | FALSE

TRUE—#Missing values remain missing regardless of interaction with formula constants.
FALSE— Default option. #Missing values can be changed by interaction with formula constants.

Description

If a #Missing data value is processed in a formula with a constant or other data-independent construct, the default behavior is that #Missing is treated like a data value. For example, if A is missing, A+5 returns 5.

If you set IGNORECONSTANTS to TRUE, #Missing is not treated like a data value. For example, if A is missing, A+5 returns #Missing.

Example

If the configuration is as follows:

IGNORECONSTANTS TRUE

then the result for X in the following formula is #Missing

IF(X)
5;
ELSE
3
ENDIF