Oracle Analytics Cloud and Server

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

BIP Default Null to Select All Parameter

Received Response
1212
Views
1
Comments

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 each selection over in the search UI. 

 

Thanks.

Code Snippet

select ' ' as segment1 from dual

union

select segment1 from gl_code_combinations 

order by 1
Tagged:

Answers

  • Rank 6 - Analytics Lead

    Hi Ari.

    On the definition of your parameter in the report set the Option to ALL Values selection to pass NULL.

    Is the default behavior once you select the MENU option for your parameter (see image)

    No need to create the Union on the query.

    Hope this helps.

    Fernando

    NullValue.JPG

Welcome!

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