cancel
Showing results for 
Search instead for 
Did you mean: 

Script logic returns no record to process

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

cecilia_petersson2
Active Participant
0 Kudos

Hi Karen,

To start with, to check which records are in scope, run the following in simulation mode in the debugger:

*WHEN *

*IS *

*REC(category=#scope)

*ENDWHEN

This displays temporary records of what's in the defined scope.

/Cecilia

Former Member
0 Kudos

Hi Karen

If you remove the WHEN condition - does it behave any different?