MDX Functions that Return a Boolean

The following MDX functions return a Boolean (TRUE or FALSE). These functions are useful for conditional testing in Essbase.

Table 4-31 MDX Boolean Functions

Function	Result
Is	Returns TRUE if two members are identical.
IsAccType	Returns TRUE if the current member has the associated accounts tag.
IsAncestor	Returns TRUE if the first member is an ancestor of the second member.
IsChild	Returns TRUE if the first member is a child of the second member.
IsEmpty	Returns True if the value of an input numeric-value-expression is #MISSING.
IsGeneration	Returns TRUE if the member is in a specified generation.
IsLeaf	Returns TRUE if the member is a level-0 member.
IsLevel	Returns TRUE if the member is in a specified level.
IsSibling	Returns TRUE if the first member is a sibling of the second member.
IsUda	Returns TRUE if the member has the associated UDA tag (user-defined attribute).
IsValid	Returns TRUE if the specified element validates successfuly.
Contains	Returns TRUE if a tuple is found within a set.