Set operations which returns members of set1 but removes any members that are in set2.
Syntax
...
| Code Block |
|---|
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. |
...
Following formula will aggregate all items in Item dimension without CD products ("CD player", "CD's - High density", "CD rack").
| Code Block |
|---|
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