Essbase Boolean Functions

A Boolean function returns TRUE or FALSE (1 or 0, respectively). Boolean
functions are generally used in conjunction with the IF command to provide
a conditional test. Because they generate a numeric value, however, Boolean
functions can also be used as part of a member formula.

Boolean functions are useful because they can determine which formula
to apply based on characteristics of the current member combination. For example,
you may want to restrict a calculation to those members in a dimension that
contain input data. In this case, you preface the calculation with an IF test
that is based on @ISLEV (dimName, 0).

If one of the function parameters is a cross-dimensional member; for
example, @@ISMBR (Sales->Budget), all parts of the cross-dimensional member
must match all parts of the current cell to return a value of TRUE.

In the following quick-reference table, “the current member” means the
member that is currently being calculated by the function. Words in italics,
such as member, loosely indicate information
you supply to the function. For details, see the individual function topics.

Function Condition Tested
@ISACCTYPE Whether the current member has a particular accounts
tag
.
@ISANCEST Whether the current member is an ancestor of member.
@ISCHILD Whether the current member is a child of member.
@ISDESC Whether the current member is a descendant of member.
@ISGEN Whether the current member of dimension is
in generation.
@ISIANCEST Whether the current member is the same member or an ancestor of member.
@ISICHILD Whether the current member is the same member or a child of member.
@ISIDESC Whether the current member is the same member or a descendant of member.
@ISIPARENT Whether the current member is the same member or the parent of member.
@ISISIBLING Whether the current member is the same member or a sibling of member.
@ISLEV Whether the current member of dimension is
in level.
@ISMBR Whether the current member is member,
or is found in member list, or is found
in a range returned by another function.
@ISPARENT Whether the current member is the parent of member.
@ISSAMEGEN Whether the current member is in the same generation as member.
@ISSAMELEV Whether the current member is in the same level as member.
@ISSIBLING Whether the current member is a sibling of member.
@ISUDA Whether the current member of dimension has
a particular user-defined attribute string.