Skip to Content
0
Sep 28, 2015 at 12:30 PM

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

38 Views

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