Data Movement in SAP BPC

[Former Member]

Hi,

I have a requirement in which i need to move the data from cube A(source)  to cube C(target) and have following options:

1. Use write_back_init in the source application (cube A) for writing data in target application (cube C). This is basically pushing of data after performing the mapping/allocation based on the target application structure.

OR

2. Use UJQ_RUN_RSDRI_QUERY in target application (cube C) to lookup the transactional data in source application (cube A) and perform mapping/allocation and then write them within the target application.

Currently i have 2 packages based on approach 1 moving data from source to target.

1. cube A --> cube C

2. cube B --> cube C

With option 2 i can go with:

cube C performing lookup on cube A and cube B in a single object and writing them within the cube C itself.

Please let me know your thoughts if you see any pros and cons in both the approaches.

Thanks in Advance!

Abhishek

[raghu_ram]

Hi Abhishek,

Please check if the below guide helps your scenario.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b0ad38cf-9e0e-2e10-9d9a-fbf57e69cd40&override...

Regards,

Raghu