Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC 10.0 LOOKUP / ENDLOOKUP

Hi all;

I have a trouble with  my script logic,

*XDIM_MEMBERSET CATEGORY = Actual,Plan1,Plan2,Plan3

*XDIM_MEMBERSET TIME = 2012.01

*XDIM_MEMBERSET GOSTERGELER = GiderTutari

*XDIM_MEMBERSET INPUTCURRENCY = TRY,EUR,USD,GBP

 

*LOOKUP Arete_Demo

*DIM CATEGORY = "$Alloc_Plan$"

*DIM TIME = "BAS($Alloc_where_var$)"

*DIM ENF:GOSTERGELER = "Enf_Oran"

*DIM ENTITY = "CSO"

*DIM INPUTCURRENCY = "TRY"

*ENDLOOKUP

*COMMIT

*RUNALLOCATION

*FACTOR = (100+LOOKUP(ENF))/100*(USING/TOTAL)

*DIM MASRAFYERI                   WHAT = BAS(MY);                       WHERE = BAS(MY);                                USING = <<<;

*DIM MASRAFCESIDI                WHAT = BAS(MC);                       WHERE = BAS(MC);                                USING = <<<;

*DIM GOSTERGELER                WHAT = GiderTutari;                    WHERE = GiderTutari;                              USING = <<<;

*DIM CATEGORY                      WHAT = Actual;                          WHERE = $Alloc_Plan$;                           USING = Actual;

*DIM TIME                               WHAT = BAS($Alloc_what_var);     WHERE = BAS($Alloc_where_var$);           USING = BAS($Alloc_what_var$);

*ENDALLOCATION

*COMMIT

The package status : SUCCESS

But the system gives " Reference Error: LOOKUP is not defined"

In BPC 10.0, do you know any change in LOOKUP function?

Cause I tried to write in *FACTOR row: "[LOOKUP].[ENF] " , "[LOOKUP].[#ENF]", and etc..

Do you have any idea about this error?

Please help me.

Best regards

Haşim

Former Member
replied

Hi Haşim,

Due to script logic limitations it's not possible to create script exactly according to your input specifications. But if we use year as "2012" instead of "2012.TOTAL" then:

PROMPT(COMBOBOX,%Alloc_what_var%,"Choose source year: ",0,,{2011,2012,2013,2014})

PROMPT(COMBOBOX,%Alloc_where_var%,"Choose target year: ",0,,{2011,2012,2013,2014})

Script:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET GOSTERGELER = GiderTutari

*XDIM_MEMBERSET INPUTCURRENCY = $Kur_Demo$

*XDIM_MEMBERSET MASRAFYERI= MY_1

*XDIM_MEMBERSET MASRAFCESIDI= MC_1

*LOOKUP Arete_Demo

*DIM CATEGORY = "$Alloc_Plan$"

*FOR %MNTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC

*DIM M_%MNTH%:TIME = "$Alloc_where_var$.%MNTH%"

*NEXT

*DIM GOSTERGELER = "Enf_Oran"

*DIM ENTITY = "CSO"

*DIM INPUTCURRENCY = "TRY"

*ENDLOOKUP

*FOR %MNTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC

*XDIM_MEMBERSET TIME=$Alloc_what_var$.%MNTH%

*WHEN GOSTERGELER

*IS "GiderTutari"

  *REC(FACTOR = (100+LOOKUP(M_%MNTH%))/100,CATEGORY = $Alloc_Plan$,TIME = $Alloc_where_var$.%MNTH%)

*ENDWHEN

*NEXT

*COMMIT

B.R. Vadim

Message was edited by: Vadim Kalinin *REC(FACTOR = (100+LOOKUP(M_%MNTH%))/100*%VALUE%... changed to: *REC(FACTOR = (100+LOOKUP(M_%MNTH%))/100...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question