Marks the end of an IF command sequence. The ENDIF command can be used only in conjunction with IF or IF ... ELSEIF statements.
ENDIF;
"Opening Inventory" (IF (@ISMBR(Budget)) IF (@ISMBR(Jan)) "Opening Inventory" = Jan; ELSE "Opening Inventory" = @PRIOR("Ending Inventory"); ENDIF; ENDIF;)
The following example is based on the Sample Basic database. This calculation script tests to see if the current member in the Market dimension is a descendant of West or East. If so, Analytic Services multiplies the value for Marketing by 1.5. The calculation script then tests to see if the current member is a descendant of South. If so, Analytic Services multiplies the value for Marketing by .9. If the current member is not a descendant of West, East, or South, Analytic Services multiplies the value for Marketing by 1.1.
IF (@ISMBR(@DESCENDANTS(West)) OR @ISMBR(@DESCENDANTS(East)) ) Marketing = Marketing * 1.5; ELSEIF(@ISMBR(@DESCENDANTS(South)) ) Marketing = Marketing * .9; ELSE Marketing = Marketing * 1.1; ENDIF;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |