Hello Fellow Colleagues,
I want to move data from one application to another application in BPC 7.5 MS.
The challenge is that I need to aggregate some of the accounts in the Source application and push it to one account in the Destination application.
I have done the following:
I have created a property in the Source application for all the respective accounts.
Source application (HR) has HRACCOUNT,HRCOSTOBJECT,DATASRC,CATEGORY & TIME dimensions
Destination application (FIN) has FINACCOUNT, FINCOSTOBJECT,DATASRC,CATEORY,TIME,TRANSACTIONS & CHANNEL dimensions.
The property QDS in HRACCOUNT has values PEO_001 for the respective accounts and at the same time there is an account member PEO_001 in FIN application
The code is reproduced as follows:
*CALCULATE_DIFFERENCE =0
*DESTINATION_APP=FIN
*ADD_DIM CHANNEL=NO_CHAN
*ADD_DIM TRANSACTIONS=NO_TRANS
*RENAME_DIM HRACCOUNT=FINACCOUNT
*RENAME_DIM HRCOSTOBJECT=FINCOSTOBJECT
*XDIM_MEMBERSET CATEGORY =GL_ACTUAL
*XDIM_FILTER HRACCOUNT=[HRACCOUNT].PROPERTIES("QDS")="PEO_001"
*WHEN HRACCOUNT.QDS
*IS *
*REC(FACTOR-1,DATASRC="QDS_APP",HRCOSTOBJECT=HRCOSTOBJECT.QDS,HRACCOUNT=HRACCOUNT.QDS)
*ENDWHEN
*COMMIT
Let me illustrate my requirement through a small example.
2012.P01
500000 Salaries 10000
500001 Bonus 5000
500002 Overtime 3000
Total 18000
18000 should be posted in PEO-001 for 2012.P01 in FIN Application.
Looking forward to your responses...
Cheers,
Shrini