Skip to Content
Former Member
Apr 18, 2012 at 04:23 PM



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!!