business intelligence - MDX union members in different hierarchies -

what want create query shows members 2 different hierarchies side-by-side on same axis. example, this:

----------------------------------------------------------------- |                         |               product               |  ----------------------------------------------------------------- | location | total amount | qty of product | qty of product b |  ----------------------------------------------------------------- |   usa    | 9,249.23     |  2,382           | 1,009            | ----------------------------------------------------------------- |   uk     | 9,998.09     |  5,282           | 5,129            | ----------------------------------------------------------------- 

it’s clear can results need running 2 different queries, follows:

select  [measures].[sales amount] on 0, [country].[usa],[country].[uk] on 1 [cube]  [time].[year].[2010]  select  crossjoin([product].[type].members, [measures].[sales quantity]) on 0, [country].[usa],[country].[uk] on 1 [cube] [time].[year].[2010] 

i found post http://blog.crossjoin.co.uk/2009/05/20/joining-the-results-of-two-mdx-queries-together helpful little bit different case.

how can use mdx result has different hierarchies members in same axises?

maybe this:

select   {    ([product].[type].[all], [measures].[sales amount])   ,{[product].[type].members * [measures].[sales quantity]}   } on 0,   [country].[usa],[country].[uk] on 1 from[cube] [time].[year].[2010];