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.
|@ISACCTYPE||Whether the current member has a particular accounts
|@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
|@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
|@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.