Accessing XMLP Enterprise Reports via a URL

I have seen several questions around accessing a report via a URL for the XMLP Enterprise release, some of you have teased apart the mechanism and gotten it working, heres the 101 for the rest of you. Now Im assuming that you are trying to call a report via a URL from another application, that might be from a portal or maybe an APEX application.


Security


As you know the reports are placed in folders and those folders are then secured to a role and a role assigned to a user. So first off you're going to need to ensure that a user actually has access to a report in the first place and if they do then you'll need to call XMLP to render it. There are two options.
1. Use the Guest folder - this can be enabled via the server configuration file, any report in this folder is open for all to see and run. Not the best solution but if the report is not sensitive then it will work no problem.
2. Use SSO - you can hook the XMLP server up to an SSO server as a partner application to the calling application and use LDAP for both application to minimize the user maintenance. This way you call any report via a URL and as long as the user has rights to see/run the report then XMLP will render it without the need for the user to log in. Setting up LDAP and SSO are covered in the user guide now available on OTN.


Building the URL


So the basic URL for a report is as follows:
http://server:port/xmlpserver/ReportDirectory/ReportName.xdo


where


  • server:port - is the name of the server and port number where xmlp is running
  • xmlpserver - a required string, this is the name of the application
  • ReportDirectory - the folder path to the report
  • ReportName - the name of the report

This will render the complete report inside the XMLP page with all the report controls. The default template, output and parameters will be used to render the report.
For example:
http://xdopf.us.oracle.com/xmlpserver/Private/Salary+Report/Salary+Report.xdo

URL1:

If you want some more control then we need to start adding some name/value pairs to the URL. The easiest way to generate the URLs is too just export the report, the URL generated will look similar to the basic URL but the name/value pairs will be added. For example:

http://xdopf.us.oracle.com/xmlpserver/Private/Salary Report/Salary Report.xdo?_xpf=&_xpt=1&_xdo=%2FPrivate%2Fkfabian%2FSalary+Report%2FSalary+Report.xdo&dep=10&_xt=Standard&_xf=html


Lets ignore the first part of the URL, its the same as before, so we have:

?_xpf=&_xpt=1&_xdo=%2FPrivate%2Fkfabian%2FSalary+Report%2FSalary+Report.xdo&dept=10&_xt=Standard&_xf=html

Breaking this string up we have the following parameters on the URL:


  • _xpf - for internal use - just leave it as is
  • _xpt - defines whether the report output should be rendered in the full XMLP window (as above) use a value of 0 or a 1 for just the document itself.
  • _xdo - this provides the path to the current report, its optional so you can leave it out.
  • dept - this is a parameter value for the report, in this case the department for the data, notice it takes the department id. The parameter definition is to show the user the department name and then pass the id to the query. Of course you can have multiple parameters and their values on the URL
  • _xt - this controls the template to be used, this is the template name i.e. Standard not the template file name.
  • _xf - this controls the format of the output to be generated e.g. PDF, HTML, etc


Of course you'll need the obligatory '?' for the first parameter and '&' for the subsequent ones. So you can now create a URL to point to the required report and pass parameter values, output format and template.


Good Luck!
 



 

Comments:

Hai.. Does reports in BI Publisher allows to passing parameter to others applications for example Oracle Portal? Could you advise me how?

Posted by nene on August 03, 2008 at 09:31 PM MDT #

Hi Nene Something like portal ought to be passing params to Publisher, not the other way round right? Publisher is a reporting tool accepting parameters, unless you mean to be able to pass parameters thru to another system. In the current release its not supported. In 10.1.3.4 the new layer of web services will have this. We will also have a post report trigger that you can code to and pass whatever you like to other programs. Tim

Posted by Tim on August 04, 2008 at 01:52 AM MDT #

Is it possible to pass datasource name of the data block as a part of the url? I want to be able to point to two different schemas for the same report depending upon where i call the report from. I dont want to look at the option of maintaining 2 different reports because the # of sources might go up in number.

Posted by Ram Chaitanya on August 25, 2008 at 09:26 AM MDT #

Is there any way that i can open publisher report by using URL, but the publisher shouldn't prompt for user name and password. Thanks Sandeep

Posted by sandeep on September 25, 2008 at 04:18 AM MDT #

Sandeep, You will not have to pass the url if you enable single sign-on for the bi-publisher reports server AND you also enable SSO for the apache server that the url request is coming from, of course this requires Oracle IDm suite which is an extra piece. I think you might be able to pass user/passwd in the url request but that might be a security risk unless you do a POST instead of GET. Using POST brings its own set of headaches though :-(

Posted by Tolu on February 05, 2009 at 03:37 AM MST #

In the document apear that "BI Publisher allows to passing parameter" and "multiple parameters" too. But, how can I do this? If the parameter is "dept" i must be like this? &dept=10,12,14 Thanks.

Posted by Kleig on October 13, 2009 at 06:42 PM MDT #

This is an awesome site, I'll be adding you to my list

Posted by Lois English on December 09, 2009 at 06:21 AM MST #

Love your points, great work.. I haven't really thought about that yet.

Posted by internet faxing software on March 20, 2010 at 02:18 AM MDT #

Excellent read, I just passed this onto a colleague who was doing a little homework on that. And he in fact bought me lunch because I found it for him

Posted by cheap wow gold on August 03, 2010 at 12:27 PM MDT #

Hi,I'm on my second pregnancy and of course, it is different than the first. I have to force myself to eat since I don't seem to have much of an appetite (except for maybe popcicles and chewing gum) and I have horrible headaches about every third day (I'm sure they partly are because I work in a daycare). I'm in my third month. Does anyone have any suggestions?

Posted by Ellsworth Heidebrecht on August 29, 2010 at 02:34 AM MDT #

I've posted a few travel themed top ten articles too, usually about cairns and australia, I'd give a link here but then it might look like spam.

Posted by Cyrus Croker on September 10, 2010 at 03:05 PM MDT #

I dont need to call them a few times before they would do something. The bonus was I got help at the airport - more than a wheelchair.

Posted by How To Parenting on September 10, 2010 at 08:45 PM MDT #

But there is a catch - I would have to be on my own with the boys. Yes! I would be totally on my own, 24/7. They have to understand motives behind everything. They have to understand why you said what you have said.

Posted by Sandra Parenting on September 11, 2010 at 07:54 AM MDT #

Thank you for a great post

Posted by Scottsdale Appliance Repair on September 17, 2010 at 06:22 PM MDT #

Excellent job.

Posted by Brisbane pest control on September 17, 2010 at 07:41 PM MDT #

Wonderful to read!

Posted by Home Security System on September 22, 2010 at 03:48 AM MDT #

Nicki Minaj's new song Right Thru Me is really a great blessing. The hook is catchy and Nicki proves that she can still rap well in the verses!

Posted by Nicki Minaj on September 24, 2010 at 12:26 PM MDT #

Thanks for creating this. I really feel as though I know so much more about the topic than I did before. You should continue this, Im sure most people would agree youve got a gift.

Posted by Jenae Kroeger on October 20, 2010 at 02:48 PM MDT #

Hi yes I've been using the Hydroxatone system for about 6 months and am really impressed with the products. As far as toners go, the Balancing Toner is great bcs I really can almost feel it tightening my pores! The AM/PM cream leaves my skin soft and whats best is that the frown lines I have are not as deep. If you're considering trying it, do it! They have trials if you get it from the website.

Posted by hydroxatone on October 20, 2010 at 09:14 PM MDT #

Yes there is a better way ---- nuclear power. However dumb Americans watched a movie in the 1970s and thought it was the actual operation of a nuclear power plant--- then they switched to the Jerry Springer Show.

Posted by Make Windmill on October 23, 2010 at 11:47 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today