SAP BPC *DESTINATION_APP

[former_member587742]

Hi Experts,

I need to push values from model to another model "COCA".

account HRAC = ACC1 from first model equals to account CCAA = 522014 from target model COCA.

account HRAC = ACC2 from first model equals to account CCAA = 522010 from target COCA.

Four dimensions are skipped. And four dimensions are added.

Added dimensions should be taken from COSTCENTER properties, COSTCENTER exists in both models.

• as you can see I am getting an error for line 14 wher dimensions are added, when I comment it out, I am getting error message that dimension does not exist in source model.

Any thoughts please?

Thanks,

Tomas.

*XDIM_MEMBERSET RPTCURRENCY = LC,USD
*XDIM_MEMBERSET HRAC        = ACC1, ACC2
*XDIM_MEMBERSET COSTCENTER  = BAS(ALL_CC)
*XDIM_MEMBERSET DATASRC     = INPUT
*XDIM_MEMBERSET VERSION     = ACT
*XDIM_MEMBERSET TIME        = BAS(TOT.2021)

*DESTINATION_APP = COCA
*SKIP_DIM        = EMPID
*SKIP_DIM        = GRADE
*SKIP_DIM        = JOBTITLE
*SKIP_DIM        = POSITION

*ADD_DIM         = COUNTRY
*ADD_DIM         = MGMTHIER
*ADD_DIM         = PROFITCENTER
*ADD_DIM         = SEGMENT

*RENAME_DIM HRAC = CCAA

*WHEN HRAC
     *IS ACC1
          *REC(EXPRESSION = %VALUE% , HRAC=A522014, DATASRC=HR_PUSH, MGMTHIER = COSTCENTER.MGMTHIER, PROFITCENTER = COSTCENTER.PROFITCENTER, SEGMENT = COSTCENTER.SEGMENT, COUNTRY = COSTCENTER.COUNTRY)
     *IS ACC2
          *REC(EXPRESSION = %VALUE% , HRAC=A522010, DATASRC=HR_PUSH, MGMTHIER = COSTCENTER.MGMTHIER, PROFITCENTER = COSTCENTER.PROFITCENTER, SEGMENT = COSTCENTER.SEGMENT, COUNTRY = COSTCENTER.COUNTRY)
	 
*ENDW
HEN

[former_member186338]

Can you provide 2 lists of dimensions for both models?

[former_member186338 · Accepted solution]

Correct script will be:

*XDIM_MEMBERSET RPTCURRENCY = LC,USD
*XDIM_MEMBERSET HRAC        = ACC1, ACC2
*XDIM_MEMBERSET COSTCENTER  = BAS(ALL_CC)
*XDIM_MEMBERSET DATASRC     = INPUT
*XDIM_MEMBERSET VERSION     = ACT
*XDIM_MEMBERSET TIME        = BAS(TOT.2021)


*DESTINATION_APP = COCA
*SKIP_DIM= EMPID,GRADE,JOBTITLE,POSITION
*ADD_DIM COUNTRY=COSTCENTER:COUNTRY,MGMTHIER=COSTCENTER:MGMTHIER,PROFITCENTER=COSTCENTER:PROFITCENTER,SEGMENT=COSTCENTER:SEGMENT
*RENAME_DIM HRAC = CCAA
*WHEN HRAC
*IS ACC1
          *REC(EXPRESSION =%VALUE%, HRAC=A522014, DATASRC=HR_PUSH)
*IS ACC2
          *REC(EXPRESSION =%VALUE%, HRAC=A522010, DATASRC=HR_PUSH)
*ENDWHEN

Just read help:

https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/f433f0bbc46c4a53860f1410f20f...

and use correct syntax!

[former_member186338 · Accepted solution]

P.S. For target account you can also create TARGETACC property in HRAC dimension.

[former_member587742 · Accepted solution]

Vadim, it worked perfectly, I just had to add there LOCATION dim to SKIP_DIM part.

Many thanks and nice day!

Tomas.

[former_member587742]

Hi Vadim,

here is the list:

[former_member186338]

Yes, LOCATION has to be added to SKIP_DIM. That was the reason I asked to provide full dimensions list 🙂