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_Expression | MDX 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])