Functions Available Through Member Selection and the Formula Bar

Table 1. Functions Available Through Member Selection and the Formula Bar

Function

Syntax

Description

Children

Children of member (Inclusive)

The members one level below the specified parent

Descendants

Descendants of member (Inclusive)

The members at all levels below the specified parent

BottomOfHierarchy

Bottom of Hierarchy dimension

All Level 0 members

Siblings

Siblings of member (Inclusive)

The members with the same parent as the specified member

OnSameLevelAs

Same level as member

The members from the same dimension and on the same level as the specified member

SameLevelAs

(Not applicable)

All members of the same level.

OfSameGeneration

Same generation as member

The members of the same dimension and generation as the specified member

Parent

Parent of member (Inclusive)

The member one level above the specified member

TopOfHierarchy

Top of Hierarchy dimension

The top-level member of hierarchy

SystemMemberList

System-defined Member List Lev(n),dimension

The members in a specified system-defined member list

Ancestors

Ancestors of member (Inclusive)

The members at all levels above the specified member

AllMembers

All Members in Hierarchy dimension

The members of the specified dimension

Member

member

The specified member

Members

(Not applicable)

All members of the current dimension