OBIEE Dasblard list for user

http://satyaobieesolutions.blogspot.co.il/search?updated-max=2013-10-14T03:40:00-07:00&max-results=7&start=2&by-date=false

OBIEE Reports and Dashboards Best Practices

http://obieesagar.blogspot.com/2013/01/obiee-reports-and-dashboards-best.html

 Dashboard - Performance

Practice Reasoning Avoid designing dashboards that return too much data Dashboards should show summary data with ability to drill into or link to detailed information with more reports. Avoid designing requests that use overly complex queries Derived metrics should be in the data source layer first, the metadata layer second, and report layer last. Use guided navigation to link to smaller dashboards Guided navigation can be set at the dashboard or at the report level. Ensure global filters have a default value Setting value to nothing or all will return all the data and impact performance. Setting a default values creates a smaller data set enhancing readability. All embedded reports on a dashboard issue their queries at dashboard load time Take this into consideration when choosing to embed large reports or link to them. Use multiple dashboard pages to separate large reports from each other when performance becomes an issue.

OBIEE dashboard prompt - NULL

 

 

 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.