Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE and BI Publisher integration

SPowell42Feb 3 2011 — edited Feb 3 2011
Hi, have a question re: OBIEE and BI Publisher integration. We're running a horribly complicated BI Publisher report that sources from 10 or 12 different answers queries. These queries can take 30 - 45 seconds to complete. Right now, everything is on a single dashboard page - prompts so users can select values, the Answers reports, and the BI Publisher section.

The behavior I'm seeing is this: while the Answers queries are running based on the prompt values, the BI Publisher windows displays the little clock "Processing" icon. But when the Answers queries complete, instead of showing the report in the BI Publisher window, we get a "Click View Report button to generate report" message. After clicking the view button we then see the report.

So a couple of questions:

1. How to make the report show without forcing user to click on the "View" button? Note: I do already have "Auto Run" turned on for the report, thought that would do it but guess not

2. If I "hide" the Answers queries (i.e. put them into a section, and then put DISPLAY:NONE in the section CSS attributes) - will this have any negative impact?

Thanks in advance!
Scott
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details