Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

invalid relational operator error

Received Response
75
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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.