Skip to main content
Skip table of contents

Except

Set operations which returns members of set1 but removes any members that are in set2.

Syntax

CODE
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").

CODE
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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.