fbpx

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

Ancestors

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.