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. |