2

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

Daniel B
  • 3,109
  • 2
  • 33
  • 42
Khilesh Chauhan
  • 739
  • 1
  • 10
  • 36
  • Possible duplicate of [UNION in SSAS MDX query](https://stackoverflow.com/questions/48815795/union-in-ssas-mdx-query) – whytheq Feb 17 '18 at 09:54
  • Might be, but my understanding says technical implementation of Microsoft SSAS and Pentaho Mondrian (schema workbench) are different. – Khilesh Chauhan Feb 17 '18 at 15:29

0 Answers0