I need your suggestion to implement the TMVL function

26 Views

Hi All,

Earlier the values hard coded in the Lookup logics and need to change it and it will be work for ever. For this I have implemented TMVL functionality by following the below syntax. It validated successfully but when I have observe the log the values are not passed to the variable. Could you suggest me in this if any syntatical chages if required. And one more thing i.e variable decleration is possible for the datasrc, the categoey dimensions ?

LOGIC:

*LOOKUP TEST

*DIM CATEGORY = "BUDGET"

*DIM SALARY = SALARY_MI

*DIM DATASRC = INTEX

*RPTCURRENCY = LC

*ACCOUNT = 87647

*TIME = "%TIME_SET%"

*ENDLOOKUP

*WHEN CATEGORY.ID

*IS = "BUDGET"

*WHEN RPTCURRENCY

*IS = USD

*WHEN SALARY.ID

*IS SALARY_MI

*WHEN TIME

*IS %TIME_SET%

*REC(EXPRESSION =ROUND(0* LOOKUP(TEST),0),TIME=TMVL(0,%TIME_SET%),SALARY="SALARY_RATE",ACCOUNT= "475782")

*IS TMVL(+1,%TIME_SET%)

*REC(EXPRESSION=ROUND(0* LOOKUP(TEST),0),TIME=TMVL(+1,%TIME_SET%),SALARY="SALARY_RATE",ACCOUNT="475782")

*ENDWHEN

Thanks and Regards,

Krishan.