ChildrenSet
EAZYBI Returns children set of aggregate calculated member (set argument of Aggregate function).
Syntax
ChildrenSet(Member_Expression)
Arguments
| Member_Expression | MDX 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
- Function Aggregate()
- Function CascadingChildrenSet()