There was a customer request that when first going to the dashboard page in OBIEE, the report would not run until there was a value selected from the dashboard prompt. The following options were not allowed:
- Setting the initial report filter to search for no values, thereby displaying the “No Results” view.
- Having a section for the prompt and a section for the report and then collapsing the section the report was in.
- Use report level prompts.
I opened an SR to Oracle and they have said that it is not possible in the current version of OBIEE. This is an enhancement request set for Oracle 11g.
Below is the response to my SR that I got back from Oracle:
Based on my research in Knowledge Management (My Oracle Support portal), this functionality is currently not available. This was requested on Enhancement Request 5543298, which is targeted for Release 11.1.1.2.0Enhancement Bug Request 5543298 – CR 12-192I9RO /FR 12-192I9SQ DON’T RUN REPORTS AUTOMATICALLY ON INITIAL PAGE ENTI can add you to the Enhancement Request. Let me know if you have any other questions. – lizResearch:1. how to turn off auto-running (Doc ID 544692.1)Their is no way to automatically stop the dashboard from executing the reports. The solutions would be simillar to the customers where to prevent the report from returning any records one would use either a non-matching prompt value or by using filters that will return nothing initially or conditional dashboard functionality. But all these methods will show the message “no result” and still run a sql query against the database.2. Prompted dashboard automatic execution (Doc ID 496679.1) For the benefit of other readers.As discussed in Service Request 38-3149629751, there “is no way to automatically stop the dashboard from executing the reports.”The following Enhancement Request was logged to address this:****Defect 6685664, DASHBOARD REQUESTS ARE RUN AUTOMATICALLY (This was closed as a duplicate to ****Enhancement Request 5543298, which is targeted for Release 11.1.1.2.0 ****Bug 5543298 – CR 12-192I9RO /FR 12-192I9SQ DON’T RUN REPORTS AUTOMATICALLY ON INITIAL PAGE ENT“When a user navigates to a Dashboard, requests are run automatically.
Enhancement Request to be able to decide if a request on a Dashboard runs automatically or not.”Workarounds are to apply filters that return less or no values.