Move data from one Module/Application to another via script logic

[former_member409271]

Hi Experts

I am looking to Move data from one Module/Application to another via script logic

Shared Dimensions between the two Modules:

• Category  (Data to move will be ID: Actual)
• GrpDatasrc  (Data to move will be ID : Input)
• RptCurrency  (Data to move will be ID: LC)
• Time (Will be user defined or selected when kicking off the package)
• Measures  (Data to move will be ID: Periodic)

Dimensions in Source Module and not in destination

• Account  (Similar structure to StatAccount in Destination Module)
• Departments  (Don't need this in Destination, so would like the highest Level Parent data to come from here)
• LegalEntity  (Similar Structure to StatEntity in Destination)

Dimensions in Destination Module and not in Source

• AccountCategory (Data to go into ID : AC1)
• StatAccount  (Similar to Account in Source Module)
• StatIntco  (Data to go into ID : SI1)
• StatMovement  (Data to go into ID: SM1)
• StatEntity  (Similar to LegalEntity in Source Module)

A start to writing this script or Links on how to write it will help.

Many Thanks

Aadil

[former_member186498 · Accepted solution]

Hi Aadil,

see please the help online of BPC script logic Logic Keyword Reference in particular *DESTINATION_APP, *SKIP_DIM and *ADD_DIM (these links are from 7.5 help but if you need you can find also the 10 help online, anyway these functions didn't change.

see please also http://wiki.scn.sap.com/wiki/display/CPM/Business+Planning+and+Consolidation+Version+for+Microsoft

where you can find some doc about script logic.

Regards

     Roberto

[former_member409271 · Accepted solution]

Thanks Roberto, i'll go through these links, seems to be a really good starting point for me,

Much appreciated

Regards

Aadil

[Former Member]

Hi,

Refer the following links:

-Megha

[former_member409271]

Thanks Megha, helpful information in these links

[former_member186498]

Hi Megha,

this is MS forum and script logic has some difference respect to NW version of BPC so these docs are not 100% useful.

Regards

     Roberto