SubCubeUnion (MDX+)

SubCubeUnion

(MDX+)

Filters the facts performing an union operation.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one-n

Return

void

Description

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

SubCubeUnion selects all facts defined by all the parameters. For example SubCubeUnion(A,B), or SubCubeUnion( {A,B} ), will define a subCube with only the rows defined by tuples A and B.

This is similar to the set behaviour in a where clause.

Examples

SubCubeUnion()

Creates a subCube using the union operator.

In our example, we select [France] and [Spain]. This behaves like a set in the where clause or subselect.

Query

WITH
  CATEGORY HIERARCHY [Stats].[Ex]
  CATEGORY MEMBER [Stats].[Ex].[All-M].[France+Spain] AS SubCubeUnion( [Geography].[Geo].[France],[Geography].[Geo].[Spain]  )
SELECT
 [Stats].[Ex].[All-M].[France+Spain] on 0
FROM [Sales]

Result

France+Spain
7

France+Spain

Assertion : Cell Equals

WITH
  MEMBER [Measures].[France+Spain] AS ([Measures].[Amount],[Geography].[Geo].[Spain]) +  ([Measures].[Amount],[Geography].[Geo].[France])
SELECT
 [Measures].[France+Spain] on 0
FROM [Sales]

Assertion : Cell Equals

SELECT
 [Measures].[Amount] on 0
FROM [Sales]
WHERE {[Geography].[Geo].[Spain],[Geography].[Geo].[France]}

Assertion : Cell Equals

SELECT
 [Measures].[Amount] on 0
FROM  ( SELECT {[Geography].[Geo].[Spain],[Geography].[Geo].[France]} on 0 FROM [Sales])

Since Version

4.7

XMLA Properties

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

Documentation

SubCubeUnion

(MDX+)

Parameters

Return

Description

See Also

Examples

Since Version

XMLA Properties