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:
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) .
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:
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.
This is a bug for the release Oracle Business Intelligence Product Version 220.127.116.11.0 (Build 110427.0752 64-bit)
Oracle just released a patch for 11g 18.104.22.168.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:
Download the patch file from:
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.
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?