Hello,
I would like to have all reporters not included in defined groups, like
[Reporter Group].[Others] =
Aggregate(
Except(
[Reporter].[All Reporters],
{
[Reporter Group].[Group].[Group_A],
[Reporter Group].[Group].[Group_B],
[Reporter Group].[Group].[Group_C]
}
)
)
The problem is the result is all the reporterd included in the A, B, C groups.
Any idea?
Regards,
Give this a try:
aggregate( except( Descendants([Reporter].CurrentMember, [Reporter].[User]), { CascadingChildrenSet([Reporter].[Group_A]), CascadingChildrenSet([Reporter].[Group_B]),
CascadingChildrenSet([Reporter].[Group_C]), } ) )
I was facing (what looks to be) a similar problem.
The first problem is in the first argument of except(). You need to get the set of all the reporters rather than the aggregate object (which is what is returned).
The second problem would then be similar, and you need to get the set of all reporters in those groups, rather than the group objects.
Let me know if that helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.