icCube

Intersect (MDX)

Returns the intersection of two sets, optionally retaining duplicates.

Parameters

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

Return

set

Description

Returns the intersection of two sets, optionally retaining duplicates.

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

The ALL flag specifies that the function should retain duplicates from the first set; when not specified, the function does not retain duplicates.

See Also

Except Union IsIn

Examples

Special Examples (errors, null, ...)

XMLA Properties

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