Member Functions

The MDX functions that are listed here indicate their return type.
Ancestor
returns the ancestor of a member at a specified level or distance.Ancestor(<Member>,<Level>)Ancestor(<Member>,<Numeric Expression>)
ClosingPeriod
returns the last sibling among the descendants of a member to a specified level. ClosingPeriod([<Level>[,<Member>]])
Cousin
returns the child member with the same relative position under its parent member as the specified child member. Cousin (<Member1>,<Member2>)
CurrentMember
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
DataMember
returns a system-generated data member that is associated with a non-leaf member of a dimension. <Member>.DataMember
DefaultMember
returns the default member of a dimension or hierarchy. <Dimension>.DefaultMember<Hierarchy>.DefaultMember
FirstChild
returns the first child of a specified member. <Member>.FirstChild
FirstSibling
returns the first child of the parent of a specified member. <Member>.FirstSibling
Item
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.
Lag
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>)
LastChild
returns the last child of a specified member. <Member>.LastChild
LastSibling
returns the last child of the parent of a specified member. <Member>.LastSibling
Lead
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>)
NextMember
returns the next member of the level that contains the specified member. <Member>.NextMember
OpeningPeriod
returns the first sibling among the descendants of a specified member at the specified level. OpeningPeriod([<Level>[,<Member>]])
ParallelPeriod
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>]]])
Parent
returns the parent of a member. <Member>.Parent
PrevMember
returns the previous member at the level of the specified member. <Member>.PrevMember
StrToMember
returns a member from a string expression in Multidimensional Expressions (MDX) format. StrToMember(<String Expression>)