Union ( set1, set2 [,ALL] )
A set to join with set2.
A set to join with set1.
If the optional ALL keyword is used, duplicates are retained.
with
select
members(measure) on 999,
UNION(crossJoin(children(Goods.[ALL].[foods]), children([starting region].[ALL])), crossJoin(children(Goods.[ALL].[foods]), children([starting region].[ALL]))) on 111111
from [logistics.test]
where
( Goods.[foods].[nut], Transport.[railway], [starting region].[Asia].[China], [starting date].[2019].[Q3].[M7], [completion date].[2019].[Q3].[M7] );
| cost | income | quantity | ||
| nut | Asia | 123456789 | 1999.998 | 2999.9970000000003 |
| nut | America | 0 | 0 | 0 |
| nut | Europe | 0 | 0 | 0 |
| wine | Asia | 0 | 0 | 0 |
| wine | America | 0 | 0 | 0 |
| wine | Europe | 0 | 0 | 0 |
| beef | Asia | 0 | 0 | 0 |
| beef | America | 0 | 0 | 0 |
| beef | Europe | 0 | 0 | 0 |