In the EPBCS application
in Hyperion
In the EPBCS application under data exchange we are giving SQL expression sql("CASE WHEN $UD4$ LIKE 4% THEN ‘DATA * -1’ ELSE 'DATA’ END" ) here we are referencing UD1 AND DATA AS data column name but we are getting error as column not inserted or incase if prefix $DATA$ ($ PREFIX with data) in and out parameter error.
WE are following the below syntax:
syntax given in oracle ADMIN GUIDE:
The parameters are sql("")
. For example, to return the value "S1" when the UD4 source value is "031010," or otherwise return the value "S2", specify the SQL expression: sql("CASE WHEN $UD4$ = ’031010’ THEN ‘S1’ ELSE ‘S2’ END")
Tagged:
0