cancel
Showing results for 
Search instead for 
Did you mean: 

Unknown Dimension Name in Keyword "0): LOOKUP function

former_member981277
Participant
0 Kudos

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

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Thanks and Regards,

Krishna.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

ROUND is still unsupported in NW BPC. And this is really bad.

former_member981277
Participant
0 Kudos

Hi,

This logic is developed in the MS version by some one.

I am validating this llogic in the NW version as per MS version.

Let me know how can I validate it in the NW version with out any errors.

Thanks and Regards,

Krishan.

former_member186338
Active Contributor
0 Kudos

No way, ROUND operator will generate errors. You have to rewrite the logic without this operator, may be using ROUND BAdI or some other tricks. If this logic is in DEFAULT.LGF then ROUND BAdI is not a good solution.

former_member981277
Participant
0 Kudos

Hi,

My intension is multiple with .06792 and make it round figure and store the value in 2010.MAR.

I have modified this logic in the NW Version,It shown 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

*IS = "No_JobTitle"

*WHEN SALARY

*IS = "Salary_Redis"

*WHEN RPTCURRENCY

*IS = "LC"

*WHEN DATASRC

*IS = "INPUT"

REC(EXPRESSION=.07692(Staff_Additions),TIME=2010.APR,SALARY=Salary_MO)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Let me know is this the right procedure to get the right result.

Could you please help me in this.

Thanks and Regards,

Krishna.

krishna_priya1
Contributor
0 Kudos

there is HTG which expains how to round values in NW .you can find HTG [here|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/50daa919-5b80-2c10-babd-b75c6c64feed&overridelayout=true] . you might need to create a BADi for rounding

Answers (0)