Last updated on OCTOBER 13, 2016
Applies to:Oracle Business Intelligence Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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 ?
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