Oct 19, 2011 at 09:53 AM

Unknown Dimension Name in Keyword "0): LOOKUP function

27 Views

Hi,

I am doing Migration project. from BPC MS to NW 7.5 In this I have vallidated the logics in the NW version as per MS version.

I got only one error when I validate the LOOKUP function in the NW under the same application(Staff_Additions).

The error message: "Unknown Dimension Name in Keyword "0):"

Could you please help me in this and please find the code below.

*Lookup Staff_Additions

*DIM SALARY="Salary_redis"

*DIM CATEGORY="Budget"

*DIM CLIENT_GROUP="1010"

*DIM DATASRC="Input"

*DIM INTCO="Non_Interco"

*DIM RPTCURRENCY="LC"

*DIM TIME="2011.MAR"

*DIM ACCOUNT="41000"

*ENDLOOKUP

*WHEN CATEGORY

*IS = "BUDGET"

*WHEN INTCO

*IS = "Non_InterCo"

*WHEN JOB_TITLE.ID

*IS = "No_JobTitle"

*WHEN SALARY

*IS = "Salary_Redis"

*WHEN RPTCURRENCY

*IS = "LC"

*WHEN DATASRC

*IS = "INPUT"

REC(EXPRESSION=ROUND(.07692 Lookup(Staff_Additions),0),Time="2010.APR",SALARY="SALARY_MO")

*ENDWHEN

*COMMIT

Thanks and Regards,

Krishna.