This website is not affiliated with, sponsored by, or approved by SAP AG.

How to copy data from n-plan transaction cube into plan cube

All postings related to SEM only

Moderators: Snowy, thx4allthefish

How to copy data from n-plan transaction cube into plan cube

Postby geraldhe » Tue Dec 05, 2006 7:57 pm

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
geraldhe
 
Posts: 24
Joined: Mon Sep 25, 2006 8:37 pm

Postby naning » Tue Dec 05, 2006 8:55 pm

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.
naning
 
Posts: 36
Joined: Wed Aug 09, 2006 1:30 am

Postby geraldhe » Wed Dec 06, 2006 1:06 am

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
geraldhe
 
Posts: 24
Joined: Mon Sep 25, 2006 8:37 pm

Postby naning » Wed Dec 06, 2006 2:56 am

If you use fox, include both of the planning areas in the planning level selection.
naning
 
Posts: 36
Joined: Wed Aug 09, 2006 1:30 am

How to copy data from n-plan transaction cube into plan cube

Postby chriszz » Thu Dec 14, 2006 8:10 pm

Hi
Pl refer " how to .....Loop over reference data in fox formulas" by SAP.

https://www.sdn.sap.com/irj/sdn/go/port ... 7f4adc5a3c

Hope this will give some idea to your problem.

Regds
Chriz
:lol:
chriszz
 
Posts: 31
Joined: Sat Sep 16, 2006 9:32 pm

Postby geraldhe » Thu Dec 14, 2006 8:23 pm

Thank you, thumbs up.
geraldhe
 
Posts: 24
Joined: Mon Sep 25, 2006 8:37 pm


Return to SEM

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.