Skip to Content
0
Former Member
Nov 12, 2015 at 08:42 PM

Script logic returns no record to process

25 Views

I'm very new to writing scripts in BPC and could really use help in understanding why I'm not able to get the script functioning. Here is what I have:

*XDIM_MEMBERSET ACCOUNT=PRODFICP

*XDIM_MEMBERSET ENTITY=00028

*XDIM_MEMBERSET TIME=2015.JAN

*XDIM_MEMBERSET CATEGORY=JANFORECAST

*XDIM_MEMBERSET DATASRC=LOCALGAAP

*LOOKUP RATES

*DIM INTRATE:R_ENTITY="GLOBAL"

*DIM INTRATE:INPUTCURRENCY=ENTITY.CURRENCY

*DIMINTRATE:R_ACCOUNT="PROD"

*DIM INTRATE:CATEGORY="JANFORECAST"

*DIM INTRATE:TIME="2015.JAN"

*ENDLOOKUP

*WHEN ACCOUNT

*IS "PRODFICP"

*REC(EXPRESSION=LOOKUP(INTRATE),ACCOUNT="PRODFICP")

*ENDWHEN

*COMMIT

I'm running using the Logic Debugger and always returns with no record to process. What this script in intending to perform is to lookup a rate and multiply that rate to the account PRODFICP. It isn't working. Any help will be greatly appreciated.

Message was edited by: Karen Langlois