5 Replies Latest reply: May 8, 2012 12:58 PM by Roberto Vidotti RSS

SAP BPC 10 issue *DESTINATION_MODEL

Iago Conde
Currently Being Moderated

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

  • Re: SAP BPC 10 issue *DESTINATION_MODEL
    Iago Conde
    Currently Being Moderated

    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

    • Re: SAP BPC 10 issue *DESTINATION_MODEL
      Ashish Gupta
      Currently Being Moderated

      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.

      • Re: SAP BPC 10 issue *DESTINATION_MODEL
        Iago Conde
        Currently Being Moderated

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

        • Re: SAP BPC 10 issue *DESTINATION_MODEL
          Lauro Bombin
          Currently Being Moderated

          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

Actions