MDX Functions that Return a Member

The following functions return a member or a member value expression.

Table 4-24 MDX Member Functions

Function	Result
Ancestor	Returns a member that is an ancestor of the specified member, at a specified generation or level.
ClosingPeriod	Returns the last descendant of a layer, or the last child of the Time dimension.
Cousin	Returns a child member at a matching outline level and location as a member from another parent.
CurrentAxisMember	Returns the current axis member in the context of a member value expression argument.
CurrentMember	Returns the current member in the input dimension. Current is in the context of query execution mechanics. Use in combination with iterative functions such as Filter.
DateToMember	Returns the date-hierarchy member specified by the input date.
DefaultMember	Returns the default member in the input dimension.
FirstChild	Returns the first child of the input member.
FirstSibling	Returns the first child of the input member's parent.
Lag	Using the default order of members in a database outline, returns a member that is n steps behind the input member.
LastChild	Returns the last child of the input member.
LastSibling	Returns the last child of the input member's parent.
Lead	Using the default order of members in a database outline, returns a member that is n steps past the input member.
NextMember	Returns the member (in the same layer) that is one step past the input member.
OpeningPeriod	Returns the first descendant of a layer, or the first child of the Time dimension.
ParallelPeriod	Returns a member from a prior time period as the specified or default time member.
Parent	Returns a member's parent.
PrevMember	Returns the member (in the same layer) that is one step prior to the input member.
StrToMbr	Converts a string to a member name.