Saturday, April 5, 2008

OBIEE View Selector, forcing a selection.

If you have a dashboard with a view selector by default OBIEE will executed the first request from the selector when a dashboard page becomes "active". Especially if have several "heavy" request will this really slow down your dashboard and irriate the hell out of your users.

A tip is:
Add an extra title view to your report and give this the title "make a selection"
Add this extra title view to your view selector and rename it "make a selection". Be sure it's on top of the list.
This way the dashboard is forced to wait on the selection of the user:

Till Next Time

1 comment:

Anonymous said...

But doesn't the query still fire, therefore hitting the database without any prompts?