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