lookup Script Logic

[Vishwanathg7]

Dear Freinds,

I am trying to write script logic for learning LOOKUP fuction of script logic and written the below code in BPC 7.5 NW its not working. Please let me know my mistake .

  
*XDIM_MEMBERSET TIME =2009.APR
*XDIM_MEMBERSET P_ACCT=CE0004010
*XDIM_MEMBERSET CATEGORY=ACTUAL

*LOOKUP RATE
*DIM TIME="2009.APR"
*DIM CATEGORY="ACTUAL"
*DIM R_ACCT="AVG"
*DIM R_ENTITY="GLOBAL"

*DIM RATEEUR:INPUTCURRENCY="INR"
*DIM MEASURES="PERIODIC"
*ENDLOOKUP

*WHEN P_ACCT
*IS "CE0004010"
*REC(EXPRESSION=%VALUE%/LOOKUP(RATEEUR), RPTCURRENCY="INR")
*ENDWHEN

[Vishwanathg7 · Accepted solution]

below is the UJTK log but I am not getting result. Please help me .

LOG:

FILE:\ROOT\WEBFOLDERS\BPC_Demo \ADMINAPP\MGT_CONSO\TEST.LGF

USER:PARAGONDNS\BPC_CON

APPSET:BPC_Demo

APPLICATION:MGT_CONSO

[INFO] GET_DIM_LIST(): I_APPL_ID="MGT_CONSO", #dimensions=8

CATEGORY,MEASURES,P_ACCT,P_ACTIVITY,P_CC,P_DATASRC,RPTCURRENCY,TIME

#dim_memberset=3

TIME:2009.APR,1 in total.

P_ACCT:CE0004010,1 in total.

CATEGORY:ACTUAL,1 in total.

REC :%VALUE%/LOOKUP(RATEEUR)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1535.45 ms. 2 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY LOOKUP DATA FROM APPLICATION: RATE

QUERY TIME : 416.49 ms. 1 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :123.38 ms.

1 RECORDS ARE GENERATED.

CALCULATION END.

SCRIPT RUNNING TIME IN TOTAL:2.42 s.

[Former Member · Accepted solution]

Hi,

Please add *COMMIT at the end of the script. Basically, your script is able to generate the record, as you can see "1 RECORDS ARE GENERATED." in the log. However, its not getting saved in the database. You need the *COMMIT statement for this.

Hope this helps.

[Former Member · Accepted solution]

in BPC 7.5 NW ,Please see the LOOKUP SAMPLE CODE:

*LOOKUP RATE

*DIM RATEEUR:TIME="2006.AUG"

*DIM RATEEUR:CATEGORY="ACTUAL"

*DIM RATEEUR:R_ACCT="AVG"

*DIM RATEEUR:R_ENTITY="GLOBAL"

*DIM RATEEUR:INPUTCURRENCY="INR"

*DIM RATEEUR:MEASURES="PERIODIC"

*ENDLOOKUP

*WHEN P_ACCT

*IS "CE0004010"

*REC(EXPRESSION=%VALUE%/LOOKUP(RATEEUR), RPTCURRENCY="INR")

*ENDWHEN

*COMMIT

[Former Member]

Hi,

Are you getting any specific error or is it just not giving you the proper result?