How to run a BI Publisher report as an analysis?

This document gives a step-be-step description of how to link a BI Publisher report to an analysis, which can then be used in an infolet.

Step 1: obtain the url from your BI Publisher report.

Navigate to the xmlpserver (main url of your environment followed by /xmlpserver) and run your report. Then go the options in the upper right hand corner, select Share Report Link, Document Only:

Copy the url, but make sure you change the parameter xpt to 1.:

Copy the resulting url into the following piece of HTML:

<iframe src="YOURURL" height="600" width="980" FRAMEBORDER=NO />

Make sure you set the height and width to the values appropriate to your report. Also, the url as copied will look like https://POD.fa.em2.oraclecloud.com:443/xmlpserver/... This means that the environment is hard coded, and thus would give an issue after a P2T. To get around this, change the first part to ../../../xmlpserver/.. The ../ part means that the current url is taken, but the system will move a few directories back and start from there. As a normal URL of the application looks like https://POD/hcmUI/faces, the actual POD of the current environment is used. You need to test the number of ../ repetitions for your environment.

Step 2: Create an Analysis.

Navigate to your biee environment (main url of your environment followed by /analytics/saw.dll?bieehome)

Create a new analysis and use a subject area to which the end user will have access:

Now click on the Results tab. You can remove the auto-generated title and table.

Create a new view and select the view type narrative:

Edit the resulting view and check the Contains HTML Markup box. Now enter your piece of HTML described in step 1 into the Narrative field. When you navigate out of this field the report will show below:

Click Done and Save the Analysis. 

Step 3: Link the report to an infolet.

Now you can use this analysis in your infolet.