The MDX functions
that are listed here indicate their return type.
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>)