Set operations which returns members of set1 but removes any members that are in set2.
Syntax
Except( Set_Expression_1 , Set_Expression_2 )
Arguments
Set_Expression_1 | MDX expression that returns set of members which should be included in the final set. |
|---|---|
Set_Expression_2 | MDX expression that returns set of members which should be excluded from the first set in the final set. |
Examples
Following formula will aggregate all items in Item dimension without CD products ("CD player", "CD's - High density", "CD rack").
Aggregate(
Except(
[Item].[Item].Members,
{
[Item].[AUDIO - Audio Products].[10106 - CD player],
[Item].[AUDIO - Audio Products].[10107 - CD's - High density],
[Item].[AUDIO - Audio Products].[10109 - CD rack]
}
)
)
See also
- Function Aggregate