Skip to Content
0
Former Member
Jan 05, 2012 at 12:49 AM

Lookup issue

11 Views

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(none of which work)

*DIM TIME=PRIOR

*DIM TIME=PRIOR(1)

*DIM TIME=GET(TIME=PRIOR)

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

*ENDWHEN

*ENDWHEN