Biee in the dashboard to indicate how empty values are removed

BIEE instrument panel Remove null value

Encountered a dashboard prompt null value issue, version: 11.1.1.6.0
Problem Description: Dashboard hint field in database bottom data no null value when creating a dashboard prompt, drag out a field ' County and County ', click the drop-down box and find the empty value ~ ~

Workaround

1. Edit the dashboard hint set the option list value to a specific column value This method is only appropriate if the field has a small number of column values and does not change

2 Edit dashboard Hint set option list value for SQL result and write SQL statement

This method uses each of the dashboard hints in this field to write a SQL

Or

1. ! = ";

3 Setting this field in the physical layer of the RPD is not a null value to save.

Reload server metadata, modification succeeded.

Biee in the dashboard to indicate how empty values are removed