Skip to Content
0
Former Member
Aug 02, 2016 at 09:07 PM

Script logic SAP BPC 10.1 using when with several conditions

31 Views

Hi experts,

I need to make a copy from one modelo to another. On the source model I have 3 dimensions : CECO, ELEMENTO_PEP, OI which have the property SEGMENTO.

The destination model has the dimension SEGMENTO.

What I need to do is:

When this condition is met = CECO="NA_CECO"and OI="NA_OI"and ELEMENTO_PEP<>"NA_PEP" then SEGMENTO= ELEMENTO_PEP:SEGMENTO

When this condition is met = CECO="NA_CECO"and OI<>"NA_OI"and ELEMENTO_PEP="NA_PEP" then SEGMENTO= OI:SEGMENTO

When this condition is met = CECO<>"NA_CECO"and OI="NA_OI"and ELEMENTO_PEP="NA_PEP" then SEGMENTO= CECO:SEGMENTO

and rec the values.

I have done this, but It doesn´t work:

*XDIM_MEMBERSET CUENTA = %CUENTA_SET%

*XDIM_MEMBERSET MONEDA = %MONEDA_SET%

*XDIM_MEMBERSET SOCIEDAD = %SOCIEDAD_SET%

*XDIM_MEMBERSET TIEMPO = %TIEMPO_SET%

*XDIM_MEMBERSET VERSION = %VERSION_SET%

*DESTINATION_APP = EEFF

*SKIP_DIM = ELEMENTO_PEP, OI, AUDITTRAIL, CECO

*ADD_DIM POS_LIQ=NA_POS_LIQ, TIPO_MOVIMIENTO=NA_TIPO_MOVIMIENTO, INDICADOR= NA_INDICADOR

//CASE 1

*WHEN CECO

*IS <>"NA_CECO"

*ADD_DIM SEGMENTO=CECO:SEGMENTO

*REC(EXPRESSION = %VALUE%, FUENTE="OPX")

//CASE 2

*WHEN OI

*IS <>"NA_OI"

*ADD_DIM SEGMENTO=OI:SEGMENTO

*REC(EXPRESSION = %VALUE%, FUENTE="OPX")

//CASE 3

*WHEN ELEMENTO_PEP

*IS <>"NA_PEP"

*ADD_DIM SEGMENTO=ELEMENTO_PEP:SEGMENTO

*REC(EXPRESSION = %VALUE%, FUENTE="OPX")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT