CascadingChildrenSet
- Elvis Kvalbergs
- Gvido
Owned by Elvis Kvalbergs
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_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'
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])