Skip to Content
0
Sep 27, 2011 at 07:45 AM

I need lookup syntax to run the logic in BPC NW7.5

169 Views

Hi,

I am doing Migration project from BPC MS7.0 to BPC NW7.5. In this I faced one problem.

I write one Script logic using Lookup syntax. Here one error message displayed when I validate the logic "Invalid Lookup strecture: Invalid application name".I am giving the right name of the application.

Please find attached logic,Let me know is there any error syntatically. But it is working in the MS version.

Please correct the code and let me know any prerequisites to run the Lookup syntax.

*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.ID

*Is = "Budget"

*WHEN INTCO.ID

*Is = "NON_INTERCO"

*When JOB_TITLE.ID

*Is = "NO_JOBTITLE"

*When SALARY.ID

*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

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT