Skip to Content
0
Former Member
Nov 08, 2012 at 02:39 PM

Destination App in BPC 7.5 MS

66 Views

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