Skip to Content

Hello everyone,

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:

Image1.png

Click Ok.

After resizing the cell I have the following:

Image2.png

Save the Report.

If you now export to PDF you will not see the image, you will see something like this:

Image3.png

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:

Image4.png

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:

PDF

Image5.png

Excel

Image6.png

That’s it!

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


On Unix:


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:

“<ResolveHTTPUrl>”=string:”<yes>”.

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:

“<PROXY>”=string:”<proxy>:<port>”

It has been a long time coming, but it is finally here.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Christophe COURTOIS

    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…

    (0) 
  2. Salim Shaikh

    Hi Jason,

    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?

    Regards,

    (0) 
  3. Ewald Rehling

    Hi Jason,

    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:

    • Should the registriy settings be made on server- or client-side?
    • How and where should proxy-credentials be entered? We need to authenticate on our proxy…

    Best regards, Ewald

    (0) 

Leave a Reply