Document toolboxDocument toolbox

CascadingChildrenSet

Returns cascading children set of aggregate calculated member (set argument of Aggregate function). If any children member is also an aggregated calculated member then it is expanded to detailed members as well.

Syntax

CascadingChildrenSet(Member_Expression)

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

There is a calculated member that consists of other aggregated calculated members, as in following example 'Last two months' consists of aggregated member 'Current Month' and 'Previous Month'

Aggregate({
  [Time].[Previous Month],
  [Time].[Current Month]
})


Then the following function would return a set of the two Month Time members from the 'Last two months' aggregated member - returning the children of each aggregated member in the 'Last two months' calculated member.

CascadingChildrenSet([Time].[Last two months])

See also

Aggregate function

ChildrenSet function