I want to union two cubes results into one. Below is one of the mdx
SELECT {[Measures].[Current Year Target],[Measures].[Actual Revenue],
[Measures].[Revenue],[Measures].[MTD %] ,[Measures].[YTD Actual]
,[Measures].[YTD Goal] , [Measures].[YTD %] } ON COLUMNS ,
NON EMPTY CROSSJOIN(
[DistrictIsManaged].[District Id].members,
[Territory].[Territory Desc].members
) ON
ROWS
FROM [Sales vs RepBudget]
WHERE ([Time].[All Time].[2005].[Quarter
1].[January],[RegionIsManaged].[Region Id].[East])

Second Cube is Sales vs SalesBudget, because they are look at different
budget dimensions
SELECT {[Measures].[Current Year Target],[Measures].[Actual Revenue],
[Measures].[Revenue],[Measures].[MTD %] ,[Measures].[YTD Actual]
,[Measures].[YTD Goal] , [Measures].[YTD %] } ON COLUMNS ,
NON EMPTY( [DistrictGeo].[District Id].members
) ON
ROWS
FROM [Sales vs SalesBudget]
WHERE ([Time].[All Time].[2005].[Quarter 1].[January],[RegionGeo].[Region
Id].[East])

As you can see, the first mdx will return district break with its territory,
while the second will return district with its totals

I tryied to cread a virtual cube , that will contain both SalesBudget and
RepBudget, but could not do it, since One Budget will go down to the
territory, while the other will go to the district, and the data is not the
same for both.

thank you