You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Default Null to Select All Parameter

Received Response
64
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Content

Is there a way to default the value in a LOV to null/blank when you have the option to "select all" in the LOV. Currently, the "All" is defaulted even when I change the order of the SQL statement in the LOV menu, the Parameter "Default Value" column (I know for Sysdate, the syntax is {$sysdate()$} so if there is anything like this) or the report parameter menu. I have not found a way to default null even when I union it in my SQL statement. If anyone knows of a way other than unselecting the "All" ability and moving

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!