SET EMPTYMEMBERSETS

EMPTYMEMBERSETS stops the calculation within a FIX…ENDFIX command if the FIX evaluates to an empty member set.

Syntax

SET EMPTYMEMBERSETS ON|OFF
Parameter Description

ON

Calculation within FIX command stops if FIX evaluates to an empty member set.

OFF

Entire database is calculated, even if FIX evaluates to an empty member set.

Notes

If EMPTYMEMBERSETS is ON, and a FIX command evaluates to a empty member set, the calculation within the FIX command stops and the following information message is displayed: "FIX statement evaluates to an empty set. Please refer to SET EMPTYMEMBERSETS command." The calculation resumes after the FIX command. If a calculation script contains nested FIX commands, the nested FIX commands are not evaluated.

Example

The following calculation script does not calculate Calc Dim(Year) within the FIX command. 100-10 has no children and therefore the FIX statement evaluates to an empty member set.

SET EMPTYMEMBERSETS ON;
...
FIX(@CHILDREN("100-10"))
  Calc Dim(Year);
ENDFIX
...

The following calculation script has nested FIX commands. Calc Dim(Product) is not calculated because FIX(@CHILDREN("100-10")) evaluates to empty member set. Calc Dim(Year) is not calculated even though the nested FIX("New York") does not evaluate to an empty member set.

SET EMPTYMEMBERSETS ON;
...
FIX(@CHILDREN("100-10"))
  FIX("New York")
    Calc Dim(Year);
  ENDFIX
Calc Dim (Product);
ENDFIX
...