Is There A Way To Remove NULL From LOV Dashboard Prompts (Doc ID 2168455.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Goal

We get NULL in the LOV from list of Years query on Time Dimension Table, which does not have NULL data.
Our TIME Dimension Table is based on a Recursive View, it doesn't have null or 0 dates.
1) We do not have any NULL data in our Time Hierarchy.
2) the Queries when run in the console do not return NULL
3) only the Dashboard Prompts show a NULL selection.
4) the Null Selection shows in Other List of Values that are created by a query as well,
   even if the query is designed to never return a NULL Value.

How to eliminate the NULL option appearing in Dashboard Prompt's List Of Values ?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms