BefImport Script & Select Stmt
edited Sep 15, 2015 10:09AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered ✓
I have created a select statement to pull the current FX rates from EBS. I've put it into the BefImport script to be called when the location name is ORACLEFX. I want the Jython to take the periodname and attach a "'__-" in front and a "'"so that I can use the result (i.e. '__-May-15') in the select statement (i.e. Select where conversion_date like ?). Unless I hardcode the periodname as a parameter in the fdmAPI.executeQuery, it doesn't work. I always get a result that no records were pulled. What am I doing wrong? Here's a sample of my code:
Tagged:
0