.png)
Except (MDX)
SQL Server 2005
Updated:
17 July 2006
MDX Function Reference (MDX)
Evaluates two sets and removes those tuples in the first set that also exist in the second set, optionally retaining duplicates.
The following example demonstrates the use of this function.
This query shows the quantity of orders for all products,
with the exception of Components, which are not
sold.
SELECT
[Date].[Month of Year].Children ON COLUMNS,
Except
([Product].[Product Categories].[All].Children ,
{[Product].[Product Categories].[Components]}
) ON ROWS
FROM
[Adventure Works]
WHERE
([Measures].[Order Quantity])
Reference
- (Except) (MDX)MDX Function Reference (MDX)
