All eazyBI for Jira eazyBI for Confluence Private eazyBI

FirstChild

Returns the first child of a specified member.

Syntax

Member_Expression.FirstChild

Arguments

Member_ExpressionMDX 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.