Script Logic: GET Function retrieves 0 - BPC 10 MS

[Former Member]

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.

[cecilia_petersson2 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Cecilia,

Thanks, I'll try it at the office today. But anyway, why when I passed GET(Tiempo="2012.11") alone, it returned 0? As far as I understand it uses the same scope of the xdim_memberset.

I'll let you know if it's working with version change.

Thanks again

[cecilia_petersson2 · Accepted solution]

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