Load data from one Application to another in BPC NW 7.5

[Former Member]

Hi

I have a requirement to load data from One application to another application.

eg. HR Plannning to CostCenter Planning.

I am aware of a method to load data using transformation file mapping source and target dimensions and run DM package and this works fine.

However, the challenge is if i try to automate this process then i will have to hardcode the application tech name and save as variant to use that in process chain. Now, if i hardcode the tech name of the application then it might happen that during full optimization the tech name might change and the automation load will fail.

so how to handle this situation? any standard practices available?

appreciate your inputs/thoughts.

Regards.

[Former Member · Accepted solution]

Hi,

You can try using destination_app in your script logic for transferring the data from one app to another. This script logic can be run through the DM package. In this case, you dont have to give any technical name of the cube.

Hope this helps.

[Former Member · Accepted solution]

Hi,

Thanks for your inputs.

I have created a new script logic with syntax as below -

• DESTINATION_APP = CC_PLAN ( I have a similar dimension set in both the applications)

Now which DM package is optimal to run the logic? Also if i intend to create custom DM which process chain should i use?

Regards.

[Former Member · Accepted solution]

Hi,

The best way would be to create a custom DM package. Before that create a copy of a standard process chain (lets say fx trans). Create a copy of this. Then create a copy of the fx trans DM package. Change the reference of the script logic name in the advanced script of the DM package.

Hope this helps.

[Former Member · Accepted solution]

Hi,

This is the exact syntax written in script logic

*DESTINATION_APP = CC_PLAN

Syntax wise validation look ok. However, nothing happens when i run the logic. Am i missing something here?

Can you share the exact syntax for the same?

Thanks.

[Former Member · Accepted solution]

Hi,

Exactly. The main problem is that there is no statement to transfer the data. Please take a look at the below link from help.sap:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/f4/33f0bbc46c4a53860f1410f20ffb8b/content.htm

Since the structure of both the applications is same, you dont require add_dim or rename_dim, etc. However, you definitely need the when statement.

If you want to transfer all the records, then you can have something like

*WHEN ACCOUNT
*IS *
    *REC(EXPRESSION = %VALUE%)
*ENDWHEN

Hope this helps.

[former_member190501]

Hi,

Try [DESTINATION_APP|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e025fa8d-1c22-2e10-cd9f-c488c7eeadd4?quicklink=index&overridelayout=true] (page 20)

hope it helps..

regards,

Raju