OBIEE and BI Publisher integration
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