1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Function Return Values
  4. MDX Functions that Return a Member

MDX Functions that Return a Member

The following MDX functions return a a single member from the Essbase outline.

Some of the MDX member functions, such as Parent, Cousin, and LastChild, operate based on member relationships in the outline's hierarchy. Others analyze using member sequences (Lag, Lead, NextMember, and PrevMember). CurrentMember and CurrentAxisMember are helpful for iterative processing. StrToMbr helps with string processing.

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.