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
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
...