All eazyBI for Jira eazyBI for Confluence Private eazyBI

LastSibling

Returns the last child of the parent of a member.

Syntax

Member_Expression.LastSibling

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

Return the last time member of a period

The following formula will return the last 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 last quarter of the year in which the current quarter resides in.

[Time].CurrentHierarchyMember.LastSibling

You can also retrieve the name of the last sibling member.

[Time].CurrentHierarchyMember.LastSibling.Name

Alternative usage with other functions

The same result as with the LastSibling function can be achieved with the combination of the Parent and LastChild functions.

[Time].CurrentHierarchyMember.Parent.LastChild

See also

  • Function FirstChild returns the first child of a member.
  • Function LastChild returns the last child of a member.
  • Function FirstSibling returns the first 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.