Member Relationships
This table describes which members and related members are included during filtering and member selection.
Click the include icon to the right of the relationship name to select the related members, including the currently-highlighted member.
Table 8-2 Member Relationships
Member | Which Related Members Are Included |
---|---|
Member |
The selected member |
Children |
All members in the level immediately below the selected member |
Descendants |
All descendants of the selected member, excluding the selected member |
Ancestors |
All members above the selected member, excluding the selected member |
Siblings |
All members from the same level in the hierarchy as the selected member, excluding the selected member |
Parents |
The member in the level above the selected member |
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 |
Right Siblings |
The members that appear 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 |
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 |