Skip to Content
avatar image
Former Member

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,

Capture.JPG (19.3 kB)
Capture1.JPG (15.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 06, 2016 at 09:55 AM

    IS it default.lgf? Please read my article how to ask questions about script logic!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      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.

  • Apr 06, 2016 at 09:53 AM

    At least incorrect for/next usage inside lookup - each dim has to get unique label.

    THe rest is also strange- lookup in rec without %VALUE% is a bad practice - use push instead of pull.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded