Cousin (MDX)
Returns the descendant of the specified ancestor that is at the same level and relative position in the hierarchy as the specified member.
Parameters
Name | Type | Cardinality | Default value |
member-expression | one | ||
ancestor | member-expression | one |
Return
member
Description
The cousin function is based on position of members within levels.
It returns a descendant of the specified ancestor. This descendant has the same relative position within the specified ancestor as the specified member within its own ancestor (at the level of the specified ancestor).
Special care should be taken with this function as it's very easy to switch both members and getting a unexpected result (NULL).
See Also
Examples
Special Examples (errors, null, ...)
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.