Import script to put ICP none in the Source ICP not working
edited Oct 10, 2013 6:49AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 6 commentsAnswered
Hi,
I want to put ICP None in the Source ICP field if the source Account is 290000.
I got the following script but my source ICP field is empty after importing my source file
What am I doing wrong?
Function Import_ICP_None(strField, strRecord)
'------------------------------------------------------------------
'Oracle Hyperion FDM DataPump Import Script:
'
'Created By: lordalain
'Date Created: 10/3/2013 12:42:59 PM
'
'Purpose:
'
'------------------------------------------------------------------
Account = DW.Utilities.fParseString(strField,8,16,";")
ICP = DW.Utilities.fParseString(strField,10,16,";")
Account = strField
If strField = "290000" Then
ICP = "ICP NONE"
End If
End Function
0