Mixing 2 Contexts

[fuham]

Hi,
i defined a universe where i have 2 References. one for actual data and one for plan-data. Both Tables have the same structure, but they are different tables.
For the Month in this Crosstable i take the month of the now-data.
For Understanding:

Month 1 2 3 4 .....
---------------------------------------
Now-Data 230mio 180mio 122mio 100mio ....
---------------------------------------
Plan-Data 180mio 180mio 180mio 180mio

can i not combine the now and plan-data? How can i do this? the datas are sums of much records for every month.
thx.

 

[blom0344]

Not entirely sure what you mean by 'can I not combine the now and plan data'?

The answer would be yes I you want to perform calculations on the two measures, assuming that that month is the common dimensions.

If plan an now tables are identical, my suggestion would be to use a union-query to fetch the data creating an additional object in each context that holds 'now' for the now-data and 'plan' for the plan-data.

For identical data-structures union-queries are the most elegant solutions

T. Blom
Information analyst
tbl@shimano-eu.com