- (Except) (MDX)

Performs a set operation that returns the difference between two sets, removing duplicate members.


Set_Expression - Set_Expression

Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

A set that contains members that are not shared by both specified parameters.

The - (Except) operator is functionally equivalent to the Except function.

The following example demonstrates the use of this operator.

// This query shows the quantity of orders for all products,
// with the exception of Assembly Components, which are not
// sold.
SELECT 
   [Date].[Calendar Month of Year].Children ON COLUMNS,
   [Product].[Product Categories].[All].Children 
   - [Product].[Product Categories].[Assembly Components] ON ROWS
FROM
    [Adventure Works]
WHERE
    ([Measures].[Order Quantity])

Community Additions

ADD
Show: