Functions Available Through Member Selection and the Formula Bar

The functions listed in Table -5 can be selected from the Functions tab in the Select Member dialog box, and they can be entered dynamically in the formula bar.

Table -5 Functions Available Through Member Selection and the Formula Bar

Function	Parameters Needed	Description
AllMembers	All Members in Hierarchy dimension	Members of the specified dimension
Ancestors	Ancestors of member (Inclusive)	Members at all levels above the specified member
BottomOfHierarchy	Bottom of Hierarchy dimension	All Level 0 members
TopOfHierarchy	Top of Hierarchy dimension	Top-level member of hierarchy
Children	Children of member (Inclusive)	Members one level below the specified parent
Descendants	Descendants of member (Inclusive)	Members at all levels below the specified parent
Parent	Parent of member (Inclusive)	Member one level above the specified member
Siblings	Siblings of member (Inclusive)	Members with the same parent as the specified member
Member	member	The specified member
Members	N/A	Members of the current dimension
OfSameGeneration	Same generation as member	Members of the same dimension and generation as the specified member
OnSameLevelAs	Same level as member	Members from the same dimension and on the same level as the specified member Note: In Planning, OnSameLevelAs only works with level 0 members.
SameLevelAs	N/A	Members of the same level
SystemMemberList	System-defined Member List Lev(n),dimension	Members in a specified system-defined member list