Designates a conditional test and conditions that are performed if the preceding IF test generates a value of FALSE. For this reason, multiple ELSEIF commands are allowed following a single IF.
ELSEIF( condition ) statement ; [ ...statement
; ]
ELSEIF | ELSE | ENDIF
| condition | Formula or function that returns a Boolean value of TRUE (a nonzero value) or FALSE (a zero value). |
| statement | Those operations that are to be performed in the event that the IF test (including the ELSE command) produces a FALSE, or 0, result. |
IF (condition)
statement;
IF (condition)
statement;
ELSEIF (condition)
statement;
ENDIF;
statement;
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 |