Union
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
Example
This example unions Q4, 2010 and Q4, 2009:
{{[data].^[data Hierarchy].[2010].[Q4 2010]},{[data].^[data Hierarchy].[2009].[Q4 2009]}}