SubCubeComplement (MDX+)

Filters the facts performing a complement operation.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one

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.

Examples

SubCubeComplement()

Creates a subCube using the Complement operator.

In our example, everything except [France].

Query

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]

Result

All but France
1019

All but France

1019

Assertion : Cell Equals

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]

Assertion : Cell Equals

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.