Question:
I tried to use function 'copy' or FOX formula to copy actual data from loading model transaction cube to planning model transaction cube in a multi-plan area, but failed.
The formula likes {Akey-figure, version-P } = {Akey-figure,version-A}.
Is I'm missing definition? Any idea, is deeply appreciated.
Best Regard,
Gerald
Answer:
What are version-P and version-A ?
You can use Copy function to do that, just define the Field to be change is Pl.area, and then fill in the planning area from and to.
Answer:
again,
Thank you, naning.
I tried and found that, if I only copy the key figure data from loading model transaction cube to planning model transaction cube, it's ok. However, if the planning model transaction cube is empty, it doesn't work, nothing could be transfered. by the way, my bw version is BW 7 with SEM 600.
Generally, how can I transfer the actual data into empty planning cube?
Best regard
Gerald
Answer:
If you use fox, include both of the planning areas in the planning level selection.
Answer:
Hi
Pl refer " how to .....Loop over reference data in fox formulas" by SAP.
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6b80d590-0201-0010-7f84-d57f4adc5a3c
Hope this will give some idea to your problem.
Regds
Chriz
Answer:
Thank you, thumbs up.