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 Block |
|---|
CascadingChildrenSet(Member_Expression) |
Arguments
| Member_Expression | MDX expression that returns a member. |
|---|
...
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 Block |
|---|
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 Block |
|---|
CascadingChildrenSet([Time].[Last two months]) |
See also
...