Union

Returns a list that is created by the union of two lists; overlapping members will appear as is.

Syntax & Usage

Union([List A], [List B])
  • [List A] represents a list of elements from a hierarchy.
  • [List B] represents another list of elements from the same hierarchy.

Example

This example "unions" Q4, 2010 and Q4, 2009:

{{[data].^[data Hierarchy].[2010].[Q4 2010]},{[data].^[data Hierarchy].[2009].[Q4 2009]}}