Skip to Content
avatar image
Former Member

Script Logic: GET Function retrieves 0 - BPC 10 MS

Hello experts,

Is there any problem with the GET function into a REC? As I read here:

http://help.sap.com/saphelp_bpc10_ms/helpdata/en/a5/719a63b6fa4ef0964d11d69c607803/content.htm

It's still supported, but when I run the following code, it puts 0 (2012.11 and 2012.12 have values):

*XDIM_MEMBERSET Auditoria  = AUD_INPUT
*XDIM_MEMBERSET Concepto = CONCEPTO_NA
*XDIM_MEMBERSET Cuenta = 520000_001
*XDIM_MEMBERSET Entidad = CCB
*XDIM_MEMBERSET Indicador = INDICADOR_NA
*XDIM_MEMBERSET Interco = I_NONE
*XDIM_MEMBERSET Moneda = COP
*XDIM_MEMBERSET Tiempo = 2012.12
*XDIM_MEMBERSET Version = VERSION_NA


*WHEN Cuenta
*IS *
*REC(EXPRESSION=GET(Auditoria="AUD_INPUT",Concepto="CONCEPTO_NA",Cuenta="520000_001",Entidad="CCB",Indicador="INDICADOR_NA",Interco="I_NONE",Moneda="COP",Tiempo="2012.11",Version="REAL"),Tiempo=2013.12)
*ENDWHEN
*COMMIT



I tried to put the entire view explicit into the get, but still no luck. What am I doing wrong?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 04, 2015 at 06:59 AM

    Hi Andres,

    All members that you're specifying in your GET formula must be included in the scope. In this case, Version REAL is missing.

    Not sure exactly what you want to do with your script, but to avoid loops you have to add *WHEN Version=VERSION_NA to achieve the same that you would with your current script.

    /Cecilia

    Add comment
    10|10000 characters needed characters exceeded

    • Ah, I didn't see that 2012.11 is also missing in the scope, so you need to add it to the scope and add another When section: *WHEN Time=2012.12.

      But basically, if you have 2012.11 in the scope, GET(Tiempo="2012.11") should work.

      /Cecilia