All eazyBI for Jira eazyBI for Confluence Private eazyBI

CalculatedChildrenSet

EAZYBI Returns children set of calculated member (set argument of Aggregate function). But won't return the children of standart members.

Syntax

 CalculatedChildrenSet(Member_Expression)

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

There is a calculated member that consists of month level members between 2 months ago and today.

Aggregate(
  [Time].[Month].DateMembersBetween('2 months ago', 'today')
)

Then the following function would return a set of the months from Time dimension that belong to the calculated member 'Last 2 months'

CalculatedChildrenSet([Time].[Last 2 months])

You can use this function to calculate the Issues created year ago vs. the last 2 months from previous expression. That would calculate results for issues created from the same period (last 2 months) year ago.

Aggregate(
  CalculatedChildrenSet([Time].CurrentHierarchyMember),
  (
    [Measures].[Issues created],
    [Time].CurrentHierarchyMember.Level.DateMember(
      DateAdd('yyyy', -1, [Time].CurrentHierarchyMember.MiddleDate)
    )
  )
)

See also