Databases Reference
In-Depth Information
Unlike the
FIX
and
ENDFIX
commands, the
IF
and
ENDIF
commands can be used
in Essbase calculation scripts as well as database outline member formulas.
Much like the
FIX
command, the
IF
command accepts a comma separated list
of conditional arguments, of which a full compliment is included in Essbase.
Always remember with
IF
and
ENDIF,
you
want to
Fix
on
Sparse
and
IF
on
Dense
.
Boolean
As you know, Boolean tests are used to check for either a true or false condition.
In an Essbase calc script, you can make good use of the Boolean test functions.
Some of the more widely used Boolean functions are
@ISUDA
,
@ISMBR
,
@ISLEV
,
@ISGEN
,
@ISPARENT
,
@ISCHILD
, and many more.
Some of the most widely used Boolean functions are discussed here:
•
@ISMBR
: This function is used to test if the current member being calculated
is a member specified by the parameter(s) entered into the function.
Syntax:
@ISMBR (membername, rangelist, mbrlist)
°
membername
—a single member name
°
rangelist
—a range of members returned by a member function
°
mbrlist
—a comma separated list of members
Example:
@ISMBR("DETROIT")
—returns true if the current member is
DETROIT
.
•
@ISLEV
: Returns true if the current member being calculated is in the same
level as the member specified in the @ISLEV parameter.
Syntax
:
@ISLEV(dimname, levelname, level number)
Example:
@ISLEV("TOTAL CUSTOMER",0)—
returns true if the current
member is in the zero level in the database outline.
•
@ISCHILD(mbrname)
: Returns true if the current member is child of
the member specified in the @ISCHILD parameter.
Syntax
:
@ISCHILD(mbrname)