Common Relationship Functions

Table 114 lists the relationship functions that return sets based on member relationships in the database outline:

Table 114. List of Relationship Functions That Return Sets

Relationship Function

Description

Children

Returns the children of the input member.

Siblings

Returns the siblings of the input member.

Descendants

Returns the descendants of a member, with varying options.

Table 115, List of Relationship Functions That Return a Single Member lists the relationship functions that return a single member rather than a set:

Table 115. List of Relationship Functions That Return a Single Member

  

Relationship Function

Description

Ancestor

Returns an ancestor at the specified layer.

Cousin

Returns a child member at the same position as a member from another ancestor.

Parent

Returns the parent of the input member.

FirstChild

Returns the first child of the input member.

LastChild

Returns the last child of the input member.

FirstSibling

Returns the first child of the input member’s parent.

LastSibling

Returns the last child of the input member’s parent.

For examples using relationship functions, see the MDX examples in the MaxL section of the Oracle Essbase Technical Reference.