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 |