Skip to Content

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

Lookup issue

Hi Guys,

I'm having one issue with Lookup function in Script Logic

Let's say I have a MODEL: HR_AUX

where I have one fixed values for KPI8 and KPI 9


LOOKUP HR_AUX

  *DIM TIME = "2016.INP"

  *DIM CATEGORY = "Forecast"

  *DIM VALUEX:HR_ACCOUNT = KPI_8

  *DIM VALUEY:HR_ACCOUNT = KPI_9

  *DIM ENTITY = "XPTO"

  *DIM RPTCURRENCY = "LC"

  *FOR %LOOP_ZCOUNTRY% = %ZCOUNTRY%

  *DIM Z_COUNTRY = %LOOP_ZCOUNTRY%

  *NEXT

  *FOR %LOOP_ZNATION% = %ZNATION%

  *DIM Z_NATION = %LOOP_ZNATION%

  *NEXT

  *DIM MEASURES = "PERIODIC"

*ENDLOOKUP

*XDIM_MEMBERSET ENTITY= XPTO

*XDIM_MEMBERSET CATEGORY = Forecast

*XDIM_MEMBERSET TIME = 2016.INP

*XDIM_MEMBERSET AUDITTRAIL = InputHR

*XDIM_MEMBERSET EMPLOYEE = %EMPLOYEE_SET%

*XDIM_FILTER EMPLOYEE = [EMPLOYEE].Properties("NEW_EMP") = X

*WHEN HR_ACCOUNT

  *IS KPI_1

  *REC(EXPRESSION = 1 * LOOKUP(VALUEX), HR_ACCOUNT = KPI_8)

  *REC(EXPRESSION = 1 * LOOKUP(VALUEY), HR_ACCOUNT = KPI_9)

*ENDWHEN

The  issue here is

in my input template when I put something input in KPI_1 for respective employee

it is filling only the KPI_9 with 10.000

and the KPI_8 it is not filling cumming blank

the problem here is:

  *DIM VALUEX:HR_ACCOUNT = KPI_8

  *DIM VALUEY:HR_ACCOUNT = KPI_9

is something here I'm doing wrong, but, I don't know what.

thanks.

Regards,

Former Member
Former Member replied

Hi Vadim,

Sorry for taking time for answering you.

You are correct, i should provide you the whole correct information.

And The issue was in support package there is a note:

0002149307 LOOKUP Value is queried out incorrectly when multi LOOKUP

and an minor adjustment of my script

Thanks again.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question