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