Logical Functions

The MDX functions that are listed here indicate their return type.

IsEmpty

returns TRUE if the evaluated expression is an empty cell value. Otherwise, FALSE is returned. IsEmpty(<Value Expression>)

returns TRUE if two compared objects are equivalent. Otherwise, FALSE is returned. <Object 1>IS Null

<Object 1>IS
                              <Object 2>

IsAncestor

returns TRUE if a specified member is an ancestor of another specified member. Otherwise, FALSE is returned. IsAncestor(<Member1>,<Member2>)

IsLeaf

returns TRUE if a specified member is a leaf member. Otherwise, FALSE is returned. IsLeaf(<Member>)

IsSibling

returns TRUE if a specified member is a sibling of another specified member. Otherwise, FALSE is returned. IsSibling(<Member1>,<Member2>)