UNION in 2 CUBES

Is it possible to write UNION query of 2 cube in Mondrian MDX ?

For example:

SELECT {[Measures].[Unit Sales],[Measures].[Store Sales]} ON COLUMNS,{[Product].members} ON ROWS
FROM [Sales_INDIA]
WHERE [Time].[1997].[Q2] 

UNION

SELECT {[Measures].[Unit Sales],[Measures].[Store Sales]} ON COLUMNS,[Product].members} ON ROWS
FROM [Sales_GERMANY]
WHERE [Time].[1997].[Q2]

ie. UNION between 2 cubes Sales_INDIA and Sales_Germany

728x90

0 Answers UNION in 2 CUBES