X

An Oracle blog about BI Publisher

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!
 





 

Join the discussion

Comments ( 20 )
  • nene Monday, August 4, 2008
    Hai..
    Does reports in BI Publisher allows to passing parameter to others applications for example Oracle Portal?
    Could you advise me how?
  • Tim Monday, August 4, 2008
    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
  • Ram Chaitanya Monday, August 25, 2008
    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.
  • sandeep Thursday, September 25, 2008
    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
  • Tolu Thursday, February 5, 2009
    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 :-(
  • Kleig Wednesday, October 14, 2009
    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.
  • Lois English Wednesday, December 9, 2009
    This is an awesome site, I'll be adding you to my list
  • internet faxing software Saturday, March 20, 2010
    Love your points, great work.. I haven't really thought about that yet.
  • cheap wow gold Tuesday, August 3, 2010
    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
  • Ellsworth Heidebrecht Sunday, August 29, 2010
    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?
  • Cyrus Croker Friday, September 10, 2010
    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.
  • How To Parenting Saturday, September 11, 2010
    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.
  • Sandra Parenting Saturday, September 11, 2010
    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.
  • Scottsdale Appliance Repair Saturday, September 18, 2010
    Thank you for a great post
  • Brisbane pest control Saturday, September 18, 2010
    Excellent job.
  • Home Security System Wednesday, September 22, 2010
    Wonderful to read!
  • Nicki Minaj Friday, September 24, 2010
    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!
  • Jenae Kroeger Wednesday, October 20, 2010
    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.
  • hydroxatone Thursday, October 21, 2010
    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.
  • Make Windmill Saturday, October 23, 2010
    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.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.