Data Movement in SAP BPC

40 Views

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