Support center for flex.bi version 4.0
ChildrenSet
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
If [Project (Job)].[A and B] is a calculated member with formula Aggregate({[Project (Job)].[A], [Project (Job)].[B]}) then
ChildrenSet([Project (Job)].[A and B]) will return {[Project (Job)].[A], [Project (Job)].[B]}
If Member_Expression is not calculated member but normal parent member which can be expanded then ChildrenSet(Member_Expression) will return Member_Expression.Children - set of children members for this parent member.
If Member_Expression is normal member which cannot be expanded then ChildrenSet(Member_Expression) will return {Member_Expression} - set of one member.