I defined dashboards in OBIEE in 10g.
But I am facing performance issue.
Every time one of the dashboards is run, it looks like it runs a blind query. Is there any way to prevent them from running a query before they select certain parameters?
It appears that even after I select values, the original session for the blind query runs in the background.
Appreciate help on this.
if you are using 10g use an intermediate report and set guided navigation to show the section only when your intermediate report returns rows.
You can follow the below blog entry to customize it for your need to not let the Dashboard run a query when nothing is selected.
Dynamic dashboard prompts and columns used in multifunctional report, full guided navigation ~ OBIEE - Oracle Business I…