Можно ли написать UNION в запросе SSAS MDX?
Например :
`SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amount]} ON COLUMNS,
{[Date].[Fiscal].[Fiscal Year].&[2002],
[Date].[Fiscal].[Fiscal Year].&[2003]} ON ROWS
FROM [Adventure_Workenter code heres_1]
WHERE ([Sales Territory].[Southwest])
UNION
SELECT
{[Measures].[Sales Amount],
[Measures].[Tax Amount] } ON COLUMNS,
{[Date].[Fiscal].[Fiscal Year].&[2002],
[Date].[Fiscal].[Fiscal Year].&[2003]} ON ROWS
FROM [Adventure_Works_2]
WHERE ([Sales Territory].[Southwest])`
т.е. СОЮЗ между 2 кубами Adventure_Works_1 и Adventure_Works_2