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

Syntax & Usage

Union([List A], [List B])
  • List A represents an initial listing of elements from a hierarchy.
  • List B represents a secondary listing of elements from the same hierarchy


This example unions Q4, 2010 and Q4, 2009:

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