Actual versus Budget in OLAP: extra budget column

[hm40]

Hello,

I have created a cube consisting of actual financial data for quarter 1 of the year 2002. It looks like this:

January February March TotalQ1
Turnover 3000 5000 4000 12000
Added vl 6800 5600 7000 19400
External 120 100 150 370

I want to add an extra column 'BudgetQ1' tot compare with TotalQ1. I have the same measures (Total turnover, Added value, and Externalhrs) for the budget cube, but do not know how to glue the Actual and the budget cubes together.
Can anyone help me please?

regards,

Hans

 

[pabloj]

Try with a virtual cube, like the process described in

http://www.databasejournal.com/features/mssql/article.php/1555281.

Stick to your guns