Skip to main content
Skip table of contents

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

CODE
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'

CODE
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.

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

See also

Aggregate function

ChildrenSet function

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.