FirstSibling
Returns the first child of the parent of a member.
Syntax
Member_Expression.FirstSibling
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 the parent of the current time member. For example, if the Quarter level is used in the report, this formula will return the first quarter of the year in which the current quarter resides in.
[Time].CurrentHierarchyMember.FirstSibling
You can also retrieve the name of the first sibling member.
[Time].CurrentHierarchyMember.FirstSibling.Name
Alternative usage with other functions
The same result as with the FirstSibling function can be achieved with the combination of the Parent and FirstChild functions.
[Time].CurrentHierarchyMember.Parent.FirstChild
See also
- Function FirstChild returns the first child of a member.
- Function LastChild returns the last child of a member.
- Function LastSibling returns the last sibling at the same level as the member.
- Function Children returns a set of all children of a member.
- Function Parent returns the parent member of a member.