Oracle Analytics Publisher (BIP)

Products Banner

invalid relational operator error

Received Response
41
Views
5
Comments

Hi - I am trying to write a query to pull report parameter value in report layout, however due to system limitation whenever my default selection for any parameter is All then its appearing as blank in report.
To show All as my selected parameter in report output, I created a data base query which is - Select Case when :p_xyz is Null then 'All' else :p_xyz end from dual
This query is working fine when all parameter value is selected for if a single value is selected but not working when multiple parameter value is selected and giving me error invalid relational operator. I tried using In function after else but no luck.
Can someone help, thanks.

Answers