Member Functions

returns the ancestor of a member at a specified level or distance.

Ancestor(<Member>,<Level>)

Ancestor(<Member>,<Numeric Expression>)

returns the last sibling among the descendants of a member to a specified level.

ClosingPeriod([<Level>[,<Member>]])

returns the child member with the same relative position under its parent member as the specified child member.

Cousin (<Member1>,<Member2>) 

returns the current member of a dimension or hierarchy during an iteration over a set of members of that dimension or hierarchy.

<Dimension>.CurrentMember

<Hierarchy>.CurrentMember

returns a system-generated data member that is associated with a non-leaf member of a dimension.

<Member>.DataMember

returns the default member of a dimension or hierarchy.

<Dimension>.DefaultMember

<Hierarchy>.DefaultMember

returns the first child of a specified member.

<Member>.FirstChild

returns the first child of the parent of a specified member.

<Member>.FirstSibling

returns a member from a specified tuple. Alternatively, it returns a tuple from a set.

<Tuple>.Item(<Index>)

Note:   If a tuple is returned, then it is a tuple function, not a member function.  

returns a member that is located at a specified number of positions before a designated member at the same level as that member.

<Member>.Lag(<Numeric Expression>)

returns the last child of a specified member.

<Member>.LastChild

returns the last child of the parent of a specified member.

<Member>.LastSibling

returns a member that is located at a specified number of positions before a designated member at the same level as that member.

<Member>.Lead(<Numeric Expression>)

returns the next member of the level that contains the specified member.

<Member>.NextMember

returns the first sibling among the descendants of a specified member at the specified level.

OpeningPeriod([<Level>[,<Member>]])

returns a member at the level of the specified member that is in the same relative position under its ancestor at the specified level.

ParallelPeriod([<Level>[,Numeric Expression>[,<Member>]]])

returns the parent of a member.

<Member>.Parent

returns the previous member at the level of the specified member.

<Member>.PrevMember

returns a member from a string expression in Multidimensional Expressions (MDX) format.

StrToMember(<String Expression>)