OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list

OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list

In the dashboard prompt, "NULL" value was added as a choice in every prompt after applying the patch OBIEE 11.1.1.6.

In the above example, to filter the NULL value in prompt

1) Edit the prompt definition for this column, select 'SQL Results' from 'Choice List Values' selection.

2) Add the condition WHERE IS NOT IN ('(Null)') to your SQL statement and click OK to preview the result. This will display all non-null values in the prompt drop-down as below.

event pooling table

http://bintelligencegroup.wordpress.com/

OBIEE11g arrow Images location

C:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\meters\arrow


C:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\meters\arrow


below image should add in the above locations then we get these arrow at column properties-->style-->images location

C:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\meters\arrow