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.