Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
running BI publisher reports via URL
Summary
running BI publisher reports via URL
Content
I have been able to successfully call a BI publisher report using a URL. However I have 4 questions
1) I'm submitting the report with output format of pdf (&_xf=pdf). Is there a way to get the pdf to display automatically in the browser without IE asking the user if they want to open it or save it? I'm used to calling Oracle Reports (from Forms) and having the content display in a browser window automatically.
2) is there a way to submit a report, via a URL, and have it burst to a printer automatically. I've not seen any documentation on an example url for this?
3) when using bi publisher to export the report to html (to generate an example url) there are several parameters like XDO_GEN_SQL_EXPLAIN_PLAN in the url. Where can I find a list of these parameters and what they actually mean. I'm assuming the values are the default and they are not actually needed (as my test calls did not included them).
3) The event driven api exists for Oracle Reports allowing a report to be submitted from pl/sql. Is there an equivalent for submitting a BI publisher report via PL/SQL?
Answers
-
1) Credentials (U.N & P.W) must be submitted once hit the url of report in browser to run the same.
2) As far as i know this feature is not available in BIP. Once Burst report generated, you have to send it to printer
3) Reg : XDO_GEN_SQL_EXPLAIN_PLAN, which version of BIP ? Can you please provide screenshot ?
4) You can check on non-standard sql DataModels
0