How to export images from a URL in Web Intelligence to PDF or Excel
Another long standing customer request has been implemented in Web Intelligence, but without great fanfare. So little so that I did not realize it had been implemented until recently.
We now have the ability to export URL based images to PDF and Excel from Web Intelligence.
This has been a complaint from users for ages and it is now possible to do.
Previously if you created a WebI report with an image from a URL, if you exported it to PDF or Excel you would get a blank cell.
Starting with BI 4.1 SP6, SP7, and BI 4.2 that is no longer necessarily the case.
You can make registry edits to allow the URL images to be embedded in both formats.
(Note that the instructions for Linux are also included in the user guide below.)
This information is found in the Web Intelligence User manuals.
I am using http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp7_webi_user_guide_en.pdf
In section 7.7 on page 448.
Here is step by step how you can do it:
Create a blank WebI document.
Add a blank cell.
Right click on the Cell and select Format Call.
Click on the Appearance selection on the left.
Select the Image from Address radio button and insert the image address as follows:
After resizing the cell I have the following:
Save the Report.
If you now export to PDF you will not see the image, you will see something like this:
Now to implement the registry edits to enable this to work.
Open the registry and go to HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\default\WebIntelligence\BlobManager
Create/Modify the string value ResolveHTTPUrl and set its value to yes.
Create/Modify the string value PROXY and set its value to <proxy>:<portnumber> where your replace <proxy> with your proxy name and <portnumber> with the proxy’s port.
It will look something like this:
Now that those are set, you can try exporting again.
Assuming the above information is configured properly, you should now see the image as such:
You can now export your URL based images to PDF or Excel from Web Intelligence.
If you are using the Web Intelligence Rich Client, you would make the same changes as above, but under the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\default\WebIntelligence\BlobManager
You need to modify the boconfig.cfg file found in the $installdir/setup folder.
In the boconfig.cfg file, locate the Software\SAP BusinessObjects\Suite XI 4.0\default\WebIntelligence\BlobManager section and do the following:
1.Create or modify the ResolveHTTPUrl value to yes to have the following line:
2.Create or modify the PROXY value to <proxy>:<port>, where <proxy> is your client proxy server and <port> is the port of that server, to have the following line:
It has been a long time coming, but it is finally here.
Thanks for pointing this, it will be useful!
But why in a hidden registry setting, and not a clean CMC, or (as so often) a flag in a .xml? That sounds like a hack from the developer. Another thing on the installation todo list...
Can you explain why it works for a static image like in your example, but doesn't work for something like the google chart images ?
Example: the code below renders fine in WebI but doesn't make it into the PDF
Thanks for the document!!
Thanks Jason- what if we are not using a proxy?
Thanks for this post!
A quick question
Our client is using load balacer that is sitting on top of two clustered Tomcat servers. How would this PROXY setting work in such case?
thanks for sharing this information in this article.
But I miss two things to be explained, which I can neither find here nor in the users guide:
Best regards, Ewald
I have the same question as Ewald,
We are SAP BO 4.2 SP2.
Any details are helpful.
Jason, Why don't you have a picture?