Lookup Issue(updated)

32 Views

Sorry, the last post was confusing so I am reposting.

Hello, could you please review the following script logic. the issue I am having is I need to multiply with the exchange rate of current month in the REC statement. but the way it is right now, it is multiplying with rate of previsous month. I tried the following(which WONT work)

*DIM TIME=%TIME_SET%

Also, please keep in mind that I cant change *when time is prior to %time_set%, as the actual script logic is lot bigger. thanks.

________________________________________

*LOOKUP RATE

*DIM RATESRC="RATEINPUT"

*DIM INPUTCURRENCY=COMPANY.CURRENCY

*DIM RATE="END"

*ENDLOOKUP

*SELECT(%AREGION%, "ID", "ACCOUNT","ASIAREGION='Y'")

*XDIM_MEMBERSET ACCOUNT=%AREGION%

*XDIM_MEMBERSET CATEGORY=ACTUAL

*XDIM_MEMBERSET DATASRC=ASREGION

*XDIM_ADDMEMBERSET DATASRC=Descendants(DATASRC.TOTAL_GAAP,99,LEAVES)

*XDIM_MEMBERSET RPTCURRENCY=USD,LC

*XDIM_MEMBERSET TIME=%TIME_SET%,PRIOR

*WHEN DATASRC

*IS ASREGION

*WHEN TIME

*IS PRIOR

*WHEN RPTCURRENCY

*IS LC

REC(FACTOR=1LOOKUP,DATASRC=ASREGION,RPTCURRENCY=USD,TIME=NEXT)

*ENDWHEN