MDX Functions that Return a Member

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

FunctionResult
AncestorReturns a member that is an ancestor of the specified member, at a specified generation or level.
ClosingPeriodReturns the last descendant of a layer, or the last child of the Time dimension.
CousinReturns a child member at a matching outline level and location as a member from another parent.
CurrentAxisMemberReturns the current axis member in the context of a member value expression argument.
CurrentMemberReturns 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.
DateToMemberReturns the date-hierarchy member specified by the input date.
DefaultMemberReturns the default member in the input dimension.
FirstChildReturns the first child of the input member.
FirstSiblingReturns the first child of the input member's parent.
LagUsing the default order of members in a database outline, returns a member that is n steps behind the input member.
LastChildReturns the last child of the input member.
LastSiblingReturns the last child of the input member's parent.
LeadUsing the default order of members in a database outline, returns a member that is n steps past the input member.
NextMemberReturns the member (in the same layer) that is one step past the input member.
OpeningPeriodReturns the first descendant of a layer, or the first child of the Time dimension.
ParallelPeriodReturns a member from a prior time period as the specified or default time member.
ParentReturns a member's parent.
PrevMemberReturns the member (in the same layer) that is one step prior to the input member.
StrToMbrConverts a string to a member name.