Applications Dimensions Type Finance GM Opex HCM Rate Account ? x x x Entity ? x x x x Category ? x x x x x Time ? x x x x x Product ? x x R_Entity ? x CostCenter ? x x Employee ? x HCM_Account ? x R_Acct ? x RptCurrency ? x x x x InputCurrency ? x DataSrc ? x x x the Script Logic for the Above Calculation ? Source Application: Opex Account Entity Category Time CostCenter DataSrc Product Amount AA1 CO1 Plan 2012.JAN CC1 INPUT Non_Product 10000 AA2 CO1 Plan 2012.JAN CC1 INPUT Non_Product 100 Reference Application: HCM HCM_Account Entity Category Time CostCenter DataSrc Employee Amount AA3 CO1 Plan 2012.INP CC1 Input E1 0.5 Result Formula= 4=1*3/2 Account Entity Category Time CostCenter DataSrc Product Amount AA4 CO1 Plan 2012.JAN CC1 INPUT Non_Product 50 Script logics to move data from 1.HCM->Opex and 2.GM and Opex->Finance Application ? Script Logic to Copy data from Actual to Plan from Current year to Next year in GM Application ? Script Logic to Lookup Rate Application and Perform Currency Translation ? Script logic to Allocation Expenses in Opex Application to All Products assuming expenses are posted at Non_Product but at CostCenter Level using Account GrossSales in GM application as reference ?