Solved: *CLEAR_DESTINATION

Hello everyone.

I am using BPC (7.5 - MS - SP04), where I have a problem in using the sentence * CLEAR_DESTINATION.

There are 5 applications in which, from 1 to 4 send data to 5 and the passage between them is performed by Script Logic.

The problem is that, for example, if I pass data to the application 1 through 5 using CLEAR_DESTINATION working properly.

But if data from the application step 2 through 5, implementing CLEAR_DESTINATION the same way as in the example above, does not work.

Any suggestions or recommendation?

Best regards.

SAP Managed Tags:
SAP Business Planning and Consolidation, version for the Microsoft platform

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Pablo,

please try sharing your script logic.

Regards

Roberto

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Roberto. i pass the contents of the scripts logics.

Any other information that you need, do not hesitate to contact me.

Best regards!


CLEAR_DESTINATION running:

//-------------------------------------------------------------------------PASAJE A EERR - INGRESOS-------------------------------------------------------------------------//



*SELECT(%ANIO%, PERIODO_ACTUAL, COMPARATIVO, ID='%COMPARATIVO_SET%') // Trae el Año Actual en funcion del comparativo seleccionado


*SELECT(%NRO%, MES_INICIO, COMPARATIVO, ID='%COMPARATIVO_SET%') //Trae el mes de inicio del comparativo seleccionado


//*SELECT(%PERIODO_COMPARATIVO% ,ID, TIEMPO, FISCAL_YEAR='%ANIO%' AND FISCAL_MONTHNUM>='%NRO%') // Trae todos los meses del año Actual a partir del Mes del comparativo
*SELECT(%PERIODO_COMPARATIVO% ,ID, TIEMPO, FISCAL_YEAR='%ANIO%')


*SELECT(%MES_INICIAL%, ID, TIEMPO, FISCAL_YEAR='%ANIO%' AND FISCAL_MONTHNUM='%NRO%') // Trae el mes inicial del Periodo Actual


*SELECT(%MES_ANTERIOR_ANIO%, PREVIOUS_YEAR, TIEMPO, ID='%MES_INICIAL%') //Trae el mes inicial del año anterior al actual


*SELECT(%ANIO_ANTERIOR%, FISCAL_YEAR, TIEMPO, ID='%MES_ANTERIOR_ANIO%') //Trae el año anterior al actual


*SELECT(%PERIODO_ANTERIOR% ,ID, TIEMPO, FISCAL_YEAR='%ANIO_ANTERIOR%')


*SELECT(%INGRESOS%, ID, CUENTACONTABLE, TIPO_SOCIO<>' ')


*SELECT(%OTROS_INGRESOS%, ID, CUENTACONTABLE, OTROS_ING<>' ')




//Limpio Aplicación Destino
*CLEAR_DESTINATION


////Pasaje a EERR Comparativo Seleccionado +  Real Año actual
*DESTINATION_APP = EERR


*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%,REAL
*XDIM_MEMBERSET DATASOURCE = CA,AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN09,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %INGRESOS%


*WHEN RATIOS
*IS KIN09
    *WHEN CUENTACONTABLE
    *IS %INGRESOS%
         *REC(FACTOR=1,RATIOS="KER02")   


*ENDWHEN
*ENDWHEN
*COMMIT


//PRUEBA MEL
////Pasaje a EERR Comparativo Seleccionado +  Real Año actual
*DESTINATION_APP = EERR


*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%,REAL
*XDIM_MEMBERSET DATASOURCE = CA,AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN14,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %INGRESOS%


*WHEN RATIOS
*IS KIN14
    *WHEN CUENTACONTABLE
    *IS %INGRESOS%
         *REC(FACTOR=1,RATIOS="KER01")   


*ENDWHEN
*ENDWHEN
*COMMIT




*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS




*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%,REAL
*XDIM_MEMBERSET DATASOURCE = CA,AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN14,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %OTROS_INGRESOS%


*WHEN RATIOS
*IS KIN14
        *WHEN CUENTACONTABLE
        *IS %OTROS_INGRESOS%


             *REC(FACTOR=1,RATIOS="KER02") 


*ENDWHEN
*ENDWHEN


*COMMIT




*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS




*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%,REAL
*XDIM_MEMBERSET DATASOURCE = CA,AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN14,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = 510750


*WHEN RATIOS
*IS KIN14
  *WHEN TIPOSOCIO.CUENTA
  *IS
  *ELSE 
             *REC(FACTOR=1,RATIOS="KER02") 


*ENDWHEN
*ENDWHEN


*COMMIT








////Pasaje a EERR Real Año Anterior al actual


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS




*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN09,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = %INGRESOS%


*WHEN RATIOS
*IS KIN09
    *WHEN CUENTACONTABLE
    *IS %INGRESOS%
         *REC(FACTOR=1,RATIOS="KER02")   


*ENDWHEN
*ENDWHEN
*COMMIT




*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS




*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN14,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = %OTROS_INGRESOS%


*WHEN RATIOS
*IS KIN14
        *WHEN CUENTACONTABLE
        *IS %OTROS_INGRESOS%


             *REC(FACTOR=1,RATIOS="KER02") 


*ENDWHEN
*ENDWHEN


*COMMIT




*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS




*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KIN14,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = 510750


*WHEN RATIOS
*IS KIN14
  *WHEN TIPOSOCIO.CUENTA
  *IS
  *ELSE 
             *REC(FACTOR=1,RATIOS="KER02") 


*ENDWHEN
*ENDWHEN


*COMMIT


CLEAR_DESTINATION not running :

//------------------------------------------PASAJE A EERR - CM_Filial de Servicio-----------------------------//

*SELECT(%ANIO%, PERIODO_ACTUAL, COMPARATIVO, ID='%COMPARATIVO_SET%') // Trae el Año Actual en funcion del comparativo seleccionado


*SELECT(%NRO%, MES_INICIO, COMPARATIVO, ID='%COMPARATIVO_SET%') //Trae el mes de inicio del comparativo seleccionado


//*SELECT(%PERIODO_COMPARATIVO% ,ID, TIEMPO, FISCAL_YEAR='%ANIO%' AND FISCAL_MONTHNUM>='%NRO%') // Trae todos los meses del año Actual a partir del Mes del comparativo


*SELECT(%PERIODO_COMPARATIVO% ,ID, TIEMPO, FISCAL_YEAR='%ANIO%')


*SELECT(%CUENTAS_CM_FS%, ID, CUENTACONTABLE, GAPA_NOGAPA<>' ') // Trae las Cuentas Contables correspondientes a Costos Medicos


*SELECT(%CUENTAS_CM_OTROS%, ID, CUENTACONTABLE, CARGA_CM_OTROS='Y') 


*SELECT(%MES_INICIAL%, ID, TIEMPO, FISCAL_YEAR='%ANIO%' AND FISCAL_MONTHNUM='%NRO%') // Trae el mes inicial del Periodo Actual


*SELECT(%MES_ANTERIOR_ANIO%, PREVIOUS_YEAR, TIEMPO, ID='%MES_INICIAL%') //Trae el mes inicial del año anterior al actual


*SELECT(%ANIO_ANTERIOR%, FISCAL_YEAR, TIEMPO, ID='%MES_ANTERIOR_ANIO%') //Trae el año anterior al actual


*SELECT(%PERIODO_ANTERIOR% ,ID, TIEMPO, FISCAL_YEAR='%ANIO_ANTERIOR%')




//Limpio Aplicación Destino
*CLEAR_DESTINATION


////Pasaje a EERR


///////////////// Cuentas FS


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%
*XDIM_MEMBERSET DATASOURCE = CA
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1), RATIOS="KER02", DATASOURCE="CA")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT




///////////////// Cuentas Otros costos medicos


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%
*XDIM_MEMBERSET DATASOURCE = IN
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_OTROS%


*WHEN RATIOS 
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_OTROS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(FACTOR=1,RATIOS="KER02",DATASOURCE="IN")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT


///////////// Frecuencia
*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = %COMPARATIVO_SET%
*XDIM_MEMBERSET DATASOURCE = CA
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM15,KER03
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS 
*IS KCM15
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1),RATIOS="KER03",DATASOURCE="CA")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT




////Pasaje a EERR Real Año actual


///////////////// Cuentas FS


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1), RATIOS="KER02")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT




///////////////// Cuentas Otros costos medicos


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_OTROS%


*WHEN RATIOS 
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_OTROS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(FACTOR=1,RATIOS="KER02")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT


///////////// Frecuencia
*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM15,KER03
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_COMPARATIVO%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS 
*IS KCM15
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1),RATIOS="KER03")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT










////Pasaje a EERR Real Año Anterior al actual


///////////////// Cuentas FS


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1), RATIOS="KER02")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT




///////////////// Cuentas Otros costos medicos


*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM21,KER02
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_OTROS%


*WHEN RATIOS 
*IS KCM21
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_OTROS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(FACTOR=1,RATIOS="KER02")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT


///////////// Frecuencia
*DESTINATION_APP = EERR
//*SKIP_DIM= RATIOS
*SKIP_DIM= ORIGENGASTO


*XDIM_MEMBERSET COMPARATIVO = REAL
*XDIM_MEMBERSET DATASOURCE = AD
*XDIM_MEMBERSET FILIALES = %FILIALES_SET%
*XDIM_MEMBERSET MONEDA = PES
*XDIM_MEMBERSET RATIOS = KCM15,KER03
*XDIM_MEMBERSET VERSION = VA
*XDIM_MEMBERSET TIEMPO = %PERIODO_ANTERIOR%
*XDIM_MEMBERSET CUENTACONTABLE = %CUENTAS_CM_FS%


*WHEN RATIOS 
*IS KCM15
*WHEN CUENTACONTABLE
     *IS %CUENTAS_CM_FS%
        *WHEN TIPOSOCIO.CUENTA
        *IS
        *ELSE 

     *REC(EXPRESSION=(%VALUE%*-1),RATIOS="KER03")   

    *ENDWHEN
       
*ENDWHEN
*ENDWHEN


*COMMIT

Hi Pablo,

I've understood that you run the same script from several applications to a destination app and it works only if you run it from all the other applications, but the 2 scripts you share are different, some *select aren't used, some *Xdim_memberset seems not ok and the scripts are long.

So please explain better what's the issue and also if you receive some error and, in case the script is the same share please only the last version not trials made before trying to simplify it deleting all unused instructions.

Thanks

Roberto

Hi Roberto,

the problem is that in the second attachment scritp the CLEAR_DESTINATION no "truncated" the destination app. However, the first script (which has implemented the same way CLEAR_DESTINATION) works well, "truncating" the destination app.

I could also find the solution to my problem:

Use CLEAR_DESTINATION after every "* DESTINATION_APP" statement

And before the lines of "* XDIM_MEMBERSET"

Thank you for your help.

Best regards.

Hi Pablo,

good that you found the solution.

Just for information, it's better to close with "Correct Answer", you can assigne it also to your last answer, so it could helps others in the future, "assumed answered" means that you didn't found a solution but you don't want to mantain the discussion open, so please change the thread assigning a "correct answer"

Regards

Roberto

Sorry, I thought I could not choose my answer as correct!

Best regards.

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

*CLEAR_DESTINATION

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

S4 HANA Brownfield Implementation: BSEG VS ACDOCA...

Journal Entry Workflow to trigger for posting thr...

Bank-to-Bank Transfer Web Service?

Re: Asset transfer ABUMN - partial transfer of wro...

Re: Different Number Range Required for Sales Bill...