Multi Planning Area BPS
I am presently working on a project on BPS.
and i am a beginner in this area. I need to extract the difference betweeen a key figure from one cube vs the other one, leaving it in a third infocube.
To do that, I define 3 planing areas based on infocubes as follows
1. Basic InfoCube whit charactheristic A, B, C and Month, KeyFigure X in Planning Area 1
2. Basic InfoCube whit charactheristic D,E, F and Month, KeyFigure Y in Planning Area 2
There is a correspondence between caharacteristics A/D, B/E and C/F
3. Transaccional InfoCube where the result must be stored with characteristics A, B and C, and Key figures X,Y and Z (X-Y). in Planning Area 3
Then I create a MultiPlanning Area including Planning Areas 1,2 y 3. A Fox FORMULA to calculate de difference in the infocube 3.
I'm not able to match data between Planning Area 1 and 2. Results shows me data from just one planning area and # for the second one.
Can anyone please help me, in finding out what is wrong or give me a step to step procedure to do this?
Any kind of help will be appreciated