All eazyBI for Jira eazyBI for Confluence Private eazyBI
All eazyBI for Jira eazyBI for Confluence Private eazyBI

ChildrenSet

EAZYBI Returns children set of aggregate calculated member (set argument of Aggregate function).

Syntax

ChildrenSet(Member_Expression)

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

The example formula access a set of sprints from a calculated member All closed Sprints with function ChildrenSet. The calculated member [Sprint].[All closed sprints] represents one member  - all closed sprints. If you need to access particular sprints you would like to split it to a set of sprints. The function ChildrenSet([Sprint].[All closed sprints]) gives a set of sprints as a result  {[Sprint].[Board 1].[Sprint 1],[Sprint].[Board 1].[Sprint 2], ... } . 

The formula uses Rank to identify a position of a particular sprint in the set of all closed sprints.

ChildrenSet([Sprint].[Active Sprints])

See sample report Sprints and story points overview for project in our Demo account. The calculated measure Active Sprint end date uses the formula above as a part of the calculation to transform calculated member Active Sprints to a set of sprints to get access to those sprint details, like end date. 

See also

Aggregate function

CascadingChildrenSet function