UNION
1. UNION (Syntax: Union(Set_Expression1, Set_Expression2 [,...n][, ALL]))
Description:
This function is used to return a set that is generated by the union of two sets, optionally retaining duplicate members.
Syntax:
Union(Set_Expression1, Set_Expression2 [,...n][, ALL])
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression1 | It is a valid MDX expression that returns a set. |
Set_Expression2 | It is a valid MDX expression that returns a set. |
Example:
SELECT
[Measures].[Internet Order Quanlity] ON 0,
UNION([Customer].[Geography].[Country],
[Customer].[Geography].[State-Province])ON 1
FROM [AdventureWorksMF]2. UNION (Syntax: {Set_Expression1 , Set_Expression2 [,...n]})
Description:
This function is used to return a set that is generated by the union of two sets, optionally retaining duplicate members.
Syntax:
{Set_Expression1 , Set_Expression2 [,...n]}
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression1 | It is a valid MDX expression that returns a set. |
Set_Expression2 | It is a valid MDX expression that returns a set. |
Example:
SELECT
[Measures].[Internet Order Quanlity] ON 0,
{[Customer].[Geography].[Country],
[Customer].[Geography].[State-Province]}ON 1
FROM [AdventureWorksMF]