Member Relationships
This table describes which members and related members are included during member selection.
Table 8-1 Member Relationships
| Relationship | Members Included |
|---|---|
|
Member |
The selected member |
|
Ancestors |
All members above the selected member, excluding the selected member |
|
Ancestors (inc) |
The selected member and its ancestors |
|
Children |
All members in the level immediately below the selected member |
|
Children (inc) |
The selected member and its children |
|
Descendants |
All descendants of the selected member, excluding the selected member |
|
Descendants (inc) |
The selected member and its descendants |
|
Siblings |
All members from the same level in the hierarchy as the selected member, excluding the selected member |
|
Siblings (inc) |
The selected member and its siblings |
|
Parents |
The member in the level above the selected member |
|
Parents (inc) |
The selected member and its parent |
|
Level 0 Descendants |
All descendants of the selected member that have no children |
|
Left Siblings |
The members that appear before the selected member with the same parent |
|
Left Siblings (inc) |
The selected member and its left siblings |
|
Right Siblings |
The members that appear after the selected member with the same parent |
|
Right Siblings (inc) |
The selected member and its right siblings |
|
Previous Sibling |
The member that appears immediately before the selected member with the same parent |
|
Next Sibling |
The member that appears immediately after the selected member with the same parent |
|
Previous Level 0 Member |
The previous level zero member that appears before the selected member Examples: PrevLvl0Mbr(Jan) returns BegBalance; PrevLvl0Mbr(Jul) returns Jun; PrevLvl0Mbr(BegBalance) returns an empty result |
|
Next Level 0 Member |
The next level zero member that appears after the selected member Examples: NextLvl0Mbr(Mar) returns Apr; NextLvl0Mbr(Dec) returns an empty result |
|
Previous Generation Member |
The member that appears immediately before the selected member within the same generation |
|
Next Generation Member |
The member that appears immediately after the selected member within the same generation |
|
Relative |
Returns a member relative to the specified member at the same generation with the specified offset. Examples: Relative("Jan", 4) returns May, which is January plus 4 months in a standard monthly Period dimension; Relative("Jan", -2) returns Nov, which is January minus 2 months in a standard monthly Period dimension. |
|
Relative Range |
Returns all of the members from the starting member to the offset member when going forward or from the offset member to the starting member when going backwards. Examples: RelativeRange("Jan", 4) returns Jan, Feb, Mar, Apr, May; RelativeRange("Jan", -2) returns Nov, Dec, Jan. |
Note:
Member relationships work for any dimension, not just the Period dimension. We've used the Period dimension in our examples because it's easier to explain as time is linear.