After I upgraded my 10g BIP reports to 11g, I was thinking of linking to the reports from the 11g BIF like what I did with old 10g OBIEE BIP. Let us review what we did in 10g firstly.

So basically when we we login to 10g xmlpserver and access the report, on the uppper right corner there shows up a link: Lind to the report

Four options are exposed for your referrence purposes. Suppose you click on No header option. You would get a link to this report like below:

http://domain_name:port/xmlpserver/report_folder/sample_report.xdo?_xpf=&_xpt=0&_xdo=%2Freport_folder%2Fsample_report.xdo&parameter1=sth&parameter2=sth&_xt=sample_reportTemplate&_xf=html&_xmode=2

Here note that _xmode=2 means you are using the no header option. So you could assume that if _xmode=3 would mean that you are chosing No Parameters option and so on.(See the table below) .

Parameter	Value	Refer To
_xmode	0	Current Page
_xmode	2	No header
_xmode	3	No Parameters
_xmode	4	Document Only

And also _xf refers to the format that how you are going to present the report. There are a few options as well in the following table.By default we are using html if we want to refer to the report through a browser. 

Now you get the link and you paste it into your browser, it would redirect you to the original report without header being showed up.

I tried to do the same thing with BIP 11g, and I figured out that it inheritantly had the same feature to get the link to the report like below.

I then generated the link through the second option: No header. It gave me the link like below:

http://domain_name:port/xmlpserver/report_folder/sample_report.xdo?_xpf=&_xpt=0&_xmode=4&_xdo=%2Freport_folder%2Fsample_report.xdo&_xpf=&_xpt=0&_xdo=%2Freport_folder%2Fsample_report.xdo&_paramsparameter1=sth&_paramsparameter2=sth&_xt=sample_reportTemplate&_xf=html&_xautorun=false

The link above is reformed a little bit from the 10g version and now I will paste it into the browser and see what happens.

It shows up the report.  But the header is still there.

Then I started trying other options except mode 2, for example, No Parameters. I got the following error.

Solutions:

This is a bug for the release Oracle Business Intelligence Product Version 11.1.1.5.0 (Build 110427.0752 64-bit)

    Oracle just released a patch for 11g 11.1.1.5.0 BIP to fix a bunch of bugs including the one we found:

        11850902 – SHARE REPORT LINK “NO PARAMETERS” AND “DOCUMENT ONLY” RENDER INCORRECTLY

    

     For details check out this link:

         http://prsync.com/oracle/bi-publisher-january-patch-for–402573/

     Download the patch file from:

         https://updates.oracle.com/Orion/Services/download/p13554951_11g_Generic.zip?aru=14460731&patch_file=p13554951_11g_Generic.zip

        Apply it according to the readme.txt included in the package. The bug would be solved! Good luck!

     

What really interested me is when you try to generate the same report from BI Answers 11g. It gave the link which looked different from the BIP version.

http://domain_name:port/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2Freport_folder%2Fsample_report.xdo&bipParams={“_xmode”:”2″,”_xpf”:””,”_xpt”:”0″,”_xdo”:”%2Freport_folder%2Fsample_report.xdo”,”_paramsparameter1″:””,”_paramsparameter2″:””,”_xt”:”sample_reportTemplate”,”_xf”:”html”,”_xautorun”:”true”}

And if you apply this link to the browser, even though you keep changing _xmode from 0 to 4, it didn’t make much difference.Anyone has any idea for this issue?