Children
Returns a set of direct children members of the current member.
Syntax
Member_Expression.Children
Arguments
Member_Expression | MDX expression that returns a member. |
---|
Examples
Return the number of children issues for an issue
The following formula will return the number of direct children for each issue, for example, Standard type issues within Epic (without Sub-tasks).
Count([Issue].CurrentHierarchyMember.Children)
Count the number of Fix Versions in each Status
In this example, you can use the "Fix Version" dimension in Rows. Since the default hierarchy for this dimension is Project > Status > Fix Version, then at each of the levels you'll see the count of direct children. To see how many Fix Versions are there in each of the imported Projects, expand the "All Fix Versions" member to see the projects and then expand each individual project to see the count of Versions within each Status provided by this formula.
Count([Fix Version].CurrentHierarchyMember.Children)
Note that this will return only the number of Fix Versions imported into eazyBI account (Fix Versions that are associated with issues).
See also
- Function Count() to count the number of elements in a set.
- Function CurrentHierarchyMember returns the current member from the hierarchy that is currently used.