Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Syntax

Code Block
ChildrenSet(Member_Expression)

Arguments

Member_ExpressionMDX expression that returns a member.

...

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.

...