FDMEE and Data Load Mapping
edited May 5, 2015 6:50PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered ✓
In FDM Classic, we have a data map that uses a script like this (where varvalues(31) is cost center and result is a role)
'if varvalues(31)>="751" and varvalues(31)<= "774" Then
Result="Finance_Level9"
elseif varvalues(31)>="600" and varvalues(31)<= "649" Then
Result="Operations_Level8"
End if
we have imported this data map into FDMEE; however, when we try to load a file we get the following error:
2015-04-17 13:04:51,176 ERROR [AIF]: The script based mapping 'RL002' (IN) has failed to compile:
mismatched input 'Then' expecting COLON (<string>, line 1)
Can anyone give me an example of how the above script needs to be re-written?
Tagged:
1