OLAP Server User Guide
MDX Documentation
MDX Functions Reference

Except

(MDX)

Returns a set with all elements from the first set that do not belong to the second set.

Parameters

Name Type Cardinality Default value
  set-expression     
  set-expression     
  ALL  zero-one   

Return

set

Description

Returns a set of all elements from the first set that do not belong to the second set.

Except( {A,B,C}, {A,F,G} ) -> {B,C}

Equivalent syntax : {A,B,C} - {A,F,G}

The ALL flag parameter specifies that the function should retain duplicates; if the ALL flag is not set then \
all the duplicates are removed from the result set.

See Also

Intersect Union

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.