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

If [Project].[A and B] is a calculated member with formula Aggregate({[Project].[A], [Project].[B]}) then

ChildrenSet([Project].[A and B]) will return {[Project].[A], [Project].[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.

See also

Aggregate function

CascadingChildrenSet function