SAP BPC 10 issue *DESTINATION_MODEL

[Former Member]

Hello BPC experts, We are trying to copy data from one model to another in the same environment. We have two models REAL and PLAN and we want to copy data from REAL to PLAN. We use the DESTINATION_MODEL key words in one script logic in the source application to perform this copy. There are some dimensions in the REAL model that are not part of the PLAN model, so we skip them. There are other dimensions that have different names in both models (but they refer to the same concept -FSITEM in the PLAN model and GLACCOUNT in the REAL one-). Is in the RENAME_DIM key word when we are getting the issues. We are planning to use a property of the GLACCOUNT dimension to get the related FSITEM. The script logic we are using is the following *XDIM_MEMBERSET AUDITTRAIL=CALCULATIONFINANC *XDIM_MEMBERSET CATEGORY=REAL *XDIM_MEMBERSET CURRENCY=LC *XDIM_MEMBERSET TIME=BAS(%YEAR%.TOTAL) *DESTINATION_MODEL=PLAN *SKIP_DIM=EMPLOYEE *SKIP_DIM=CECO *RENAME_DIM GLACCOUNT=FSITEM *WHEN GLACCOUNT.ACCTYPE *IS "INC"     *REC(EXPRESSION=%VALUE%*-1,AUDITTRAIL="INPUTANUAL", FSITEM=GLACCOUNT.FSITEM) *IS "EXP"     *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTANUAL", FSITEM=GLACCOUNT.FSITEM) *ENDWHEN *COMMIT Best regards and thanks in advance!!

[Former Member · Accepted solution]

Sorry, this is how the code should look:

*XDIM_MEMBERSET AUDITTRAIL=CALCULATIONFINANC

*XDIM_MEMBERSET CATEGORY=REAL

*XDIM_MEMBERSET CURRENCY=LC

*XDIM_MEMBERSET TIME=BAS(%YEAR%.TOTAL)

*DESTINATION_MODEL=PLAN

*SKIP_DIM=EMPLOYEE

*SKIP_DIM=CECO

*RENAME_DIM GLACCOUNT=FSITEM

*WHEN GLACCOUNT.ACCTYPE

*IS "INC"    

     *REC(EXPRESSION=%VALUE%*-1,AUDITTRAIL="INPUTANUAL", FSITEM=GLACCOUNT.FSITEM)

*IS "EXP"    

     *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTANUAL", FSITEM=GLACCOUNT.FSITEM)

*ENDWHEN

*COMMIT

Kind regards

[former_member210696 · Accepted solution]

Please try if below code works -

*XDIM_MEMBERSET AUDITTRAIL=CALCULATIONFINANC

*XDIM_MEMBERSET CATEGORY=REAL

*XDIM_MEMBERSET CURRENCY=LC

*XDIM_MEMBERSET TIME=BAS(%YEAR%.TOTAL)

*DESTINATION_MODEL=PLAN

*SKIP_DIM=EMPLOYEE

*SKIP_DIM=CECO

*RENAME_DIM GLACCOUNT=FSITEM

*WHEN GLACCOUNT.ACCTYPE

*IS "INC"    

     *REC(EXPRESSION=%VALUE%*-1,AUDITTRAIL="INPUTANUAL")

*IS "EXP"    

     *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTANUAL")

*ENDWHEN

*COMMIT

Since you have already mapped GLACCOUNT in source application to FSITEM in target application, no need to consider that in your record statement.

Also, you may first try to scope your record including the two skipped dimensions (Employee and CECO), i.e. include XDIM_MEMBERSET statement for these two dimensions and then while defining Destination dimension, skip these two.

Hopefully, it should work.

[Former Member · Accepted solution]

Dear Ashish,

I need to especify the GLACCOUNT dimension in the record statement because I do not want to transfer the value to the same account, I need to transfer the value to a property of the account dimension. I am using the following script

*SELECT(%GLACCOUNINGR%,"[ID]",GLACCOUNT,"[FINAN]='INGR'")

*XDIM_MEMBERSET AUDITTRAIL=CALCULATIONFINANC

*XDIM_MEMBERSET CATEGORY=REAL

*XDIM_MEMBERSET CURRENCY=LC

*XDIM_MEMBERSET TIME=%YEAR%.JAN,%YEAR%.FEB,%YEAR%.MAR,%YEAR%.APR,%YEAR%.MAY,%YEAR%.JUN,%YEAR%.JUL,%YEAR%.AUG,%YEAR%.SEP,%YEAR%.OCT,%YEAR%.NOV,%YEAR%.DEC

*XDIM_MEMBERSET ENTITY=%ENTITY_SET%

*XDIM_MEMBERSET CANAL=CN_NULL

*XDIM_MEMBERSET CARTERA=CH_NULL

*XDIM_MEMBERSET CECO=CC_NULL

*XDIM_MEMBERSET GLACCOUNT=%GLACCOUNINGR%

*DESTINATION_MODEL=PFPLANNING

*RENAME_DIM GLACCOUNT = FSITEM

*SKIP_DIM=CARTERA *SKIP_DIM=CECO

*SKIP_DIM=CANAL

*WHEN GLACCOUNT.ACCTYPE

*IS "INC"   

     *REC(EXPRESSION=%VALUE%*-1,AUDITTRAIL="INPUTANUAL",GLACCOUNT=GLACCOUNT.FSITEM)

*IS "EXP"    

     *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTANUAL",GLACCOUNT=GLACCOUNT.FSITEM)

*ENDWHEN

*COMMIT

The problem is that the system is not recognizing the FSTIEM and is transfering all the records over the same FSITEM wich is #. This is the log we are getting:

Model: PFPLANNING - Records to be posted are 2 (calc diff = 0) CATEGORY,CURRENCY,ENTITY,AUDITTRAIL,FSITEM,TIME,SIGNEDDATA REAL,LC,E_C502,INPUTANUAL,#,2012.JAN,-83175311.9600000000

REAL,LC,E_C502,INPUTANUAL,#,2012.FEB,-39745022.9300000000

It seems that the system is not recognizing the RENAME statement. We are working on SAP BPC 10.0.0.5.0. Are there any issues related to that??

Best regards!!

[Former Member · Accepted solution]

Hello all finally this is the code we used to transfer from one model to another.

It gives the following message when validating, but it works fine: Validation status of syntax: Failed - Invalid syntax found; see statements in red

*XDIM_MEMBERSET AUDITTRAIL=CALCULATIONVNV

*XDIM_MEMBERSET CATEGORY=REAL

*XDIM_MEMBERSET CURRENCY=LC

*XDIM_MEMBERSET TIME=%YEAR%.JAN,%YEAR%.FEB,%YEAR%.MAR,%YEAR%.APR,%YEAR%.MAY,%YEAR%.JUN,%YEAR%.JUL,%YEAR%.AUG,%YEAR%.SEP,%YEAR%.OCT,%YEAR%.NOV,%YEAR%.DEC

*XDIM_MEMBERSET ENTITY=%ENTITY_SET%

*DESTINATION_MODEL=PFPLANNING

*SKIP_DIM=CARTERA

*SKIP_DIM=CECO

*RENAME_DIM GLACCOUNT=FSITEM

*RENAME_DIM PRODUCTO=FAMPRODUCTO

*WHEN GLACCOUNT.ACCTYPE

*IS "INC"    

             *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTMENSUAL",PRODUCTO=PRODUCTO.FAMPRODUCTO,GLACCOUNT=GLACCOUNT.FSITEM) *IS "EXP"                                

             *REC(EXPRESSION=%VALUE%,AUDITTRAIL="INPUTMENSUAL",PRODUCTO=PRODUCTO.FAMPRODUCTO,GLACCOUNT=GLACCOUNT.FSITEM) *ENDWHEN *COMMIT   

Best regards

[former_member186498 · Accepted solution]

Hi Lauro,

you can simplify the TIME using *XDIM_MEMBERSET TIME=%BAS(%YEAR%.TOTAL)

Kind regards

     Roberto