cancel
Showing results for 
Search instead for 
Did you mean: 

lookup Script Logic

Vishwanathg7
Participant
0 Kudos
410

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

View Entire Topic
Vishwanathg7
Participant
0 Kudos

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
0 Kudos

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
0 Kudos

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