copy data from one application to another

24 Views

Hi,

I am trying to copy data from one application to another. (Copy data from application 'FAB_CC_Budget' to application 'FAB_CC_Forecast').

Dimensions of FAB_CC_BUDGET

-

BUCategory=App_Budget

FBAccountBudget=3PSPEND

FBActivity=<ALL>

FBEntityCostcenter=<ALL>

FBRptCurrency=<ALL>

FBTime=%Period%

FBYEAR=%YEAR%

Dimensions of FAB_CC_FORECAST

-

FBCategory=F0_Category

FBAccount=3PSPEND

FBEntityCostcenter=<ALL>

FBRptCurrency=<ALL>

FBTime=%Period%

FBYEAR=%YEAR%

Please check the below Logic and let me know why its not working....

*XDim_Memberset BUCategory=App_Budget

*XDim_Memberset FBAccountBudget=3PSPEND

*XDim_Memberset FBActivity=<ALL>

*XDim_Memberset FBEntityCostcenter=<ALL>

*XDim_Memberset FBRptCurrency=<ALL>

*XDim_Memberset FBTime=%Period%

*XDim_Memberset FBYEAR=%YEAR%

*DESTINATION_APP = FAB_CC_FORECAST

*SKIP_DIM = FBActivity

*RENAME_DIM FBAccountBudget = FBAccount

*RENAME_DIM BUCategory = FBCategory

*SELECT(%Period%,"ID","FBTime")

*SELECT(%YEAR%,"ID","FBYEAR")

*WHEN BUCategory

*IS App_Budget

*REC(BUCategory=F0_Category)

*ENDWHEN

*COMMIT