FirstChild
Returns the first child of a specified member.
Syntax
Member_Expression.FirstChild
Arguments
| Member_Expression | MDX expression that returns a member. |
|---|
Examples
Return the first time member of a period
The following formula will return the first child member of a time member. For example, if the Quarter level is used in the report, this formula will return the first month for each quarter.
[Time].CurrentHierarchyMember.FirstChild
You can also retrieve the name of the first child member.
[Time].CurrentHierarchyMember.FirstChild.Name
See also
- Function LastChild returns the last child of a member.
- Function Children returns a set of all children of a member.
- Function LastSibling returns the last sibling at the same level as the member.
- Function Parent returns the parent member of a member.