fbpx

Union (MDX)

Returns a set generated by the union of a list of sets, optionally retaining duplicate members.

Parameters

Name Type Cardinality Default value
  set-expression  one-n   
  ALL  zero-one   

Return

set

Description

Returns a set generated by the union of a list of sets. This function is equivalent to the
+ operator: Union(A,B) = A + B.

By default, duplicated members (or tuples) are removed from the union. The ALL option allows for keeping those duplicated elements.

See Also

Except Intersect

Examples

Special Examples (errors, null, ...)

XMLA Properties

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