SET EMPTYMEMBERSETS

The SET EMPTYMEMBERSETS calculation command for Essbase stops the calculation within a FIX...ENDFIX command block if the FIX evaluates to an empty member set.

Syntax

SET EMPTYMEMBERSETS ON|OFF

Parameters

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 command within FIX…ENDFIX evaluates to a empty member set, the calculation 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 block. 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
...