SubCubeComplement (MDX+)

Filters the facts performing a complement operation.

Parameters

Return

void

Description

Currently only available for categories, the SubCube functions allows for filtering facts using different operations.

SubCubeComplement selects all facts not defined by the first parameter. For example SubCubeMinus(A) will define a subCube with the rows not defined by A. Like [All] - [A].

Use this function for large dimensions as using the complement function might improve performance significantly.

See Also

SubCubeIntersect SubCubeMinus SubCubeOthers SubCubeSymDifference SubCubeUnion Eval

Examples

WITH
  CATEGORY HIERARCHY [Stats].[Ex]
  CATEGORY MEMBER [Stats].[Ex].[All-M].[All but France] AS SubCubeComplement( [Geography].[Geo].[France] )
SELECT
 [Stats].[Ex].[All-M].[All but France] on 0
FROM [Sales]

WITH
  MEMBER [Measures].[All but France] AS ([Measures].[Amount],[Geography].[Geo].[All])-  ([Measures].[Amount],[Geography].[Geo].[France])
SELECT
 [Measures].[All but France] on 0
FROM [Sales]

WITH
  MEMBER [Measures].[All but France] AS Sum([Geography].[Geo].[Country]-[Geography].[Geo].[France], [Measures].[Amount])
SELECT
 [Measures].[All but France] on 0
FROM [Sales]

Since Version

4.7

XMLA Properties

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