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]}}