By default OBIEE 220.127.116.11.1 dashboard prompt shows the ‘NULL’ value as one of the drop down value though the actual value in underline column does not have any occurrence of the ‘NULL’ value. It does not make sense to display a ‘NULL’ value though it does not exist in within the underline database.
This blog is an attempt to explain how I have resolved this issue at one of the customer project, believe me it is very easy to remove the ‘NULL’ value from the drop down list.
A dashboard prompt is created for ‘Product’ attribute from a subject area based on Essbase data source.
The list of values for the dashboard prompt is as follows, it is clearly showing ‘NULL’ as one of drop down list value.
Initially I thought let us check the column property in the physical layer, it was unchecked which I believe is right as there are no ‘NULL’ values in Essbase data storage.
I have started looking into the various options linked with the prompt column; the initial settings are as follows.
Then I realized there is a radio button ‘Require user input’ which is unchecked. The option for me is to check that option and check the output. It worked.
The solution works for ‘Choice List’ but not for ‘Check Boxes’, ‘Redo Buttons’ etc. The only option which I can think of is to choose values as – ‘Specific Column Values’ and choose all possible values for dimensional attributes.
Unfortunately this option is available at prompt column level. Unfortunately I could not able to find out a central place where I can set this for all columns in prompt by default.
I hope you find this information useful.