The following functions return a member or a member value expression.
| 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. |
| 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. |