Image hyperlink in SAP BO 4.0

building reports webintelligence
1

Hi,

Needed some help with an issue.
I am using SAP BO 4.0 SP 7. It is installed on an UNIX server.
I have to requirement where based on an objects value we will show images and on clicking the image another Webi report will open.

I am reading the cell content as HTML. The code for the cell is like this:

=If([ObjectA]=1;"<a href=opendoc1 link><img src=boimg://a.gif></a>";"<a href=opendoc2 link><img src=boimg://b.gif></a>")

Here, the opendoc links are working fine. But the images are not displaying. The images are placed in the ‘images’ folder inside enterprise_xi40 directory inside the installation folder.

Can anyone help?

Regards
Nikhil

nikhilnair (BOB member since 2014-08-08)

2

Hi Nikhil,

I think that the image formula should be put within quotes
Try this:
scr=“boimg://a”+".gif"

Hope it helps!

Gentiana

GenMath :belgium: (BOB member since 2011-10-05)

3

Hi Gentiana,

Thanks. I tried this. But still the images are not displaying.

nikhilnair (BOB member since 2014-08-08)

4

[Moderator Note: Moved from General Discussion to WebIntelligence XI]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Hi

check this please

http://scn.sap.com/thread/3575394

Judia

judia (BOB member since 2008-06-24)

6

Hi Judia,

Thanks. I checked out that link. It was helpful.

But still I am facing the issue.

If i give the path of image from a website like google then it is displaying the image.
Eg: < img src=“https://www.google.co.in/logos/doodles/2014/world-cup-2014-27-5917140490125312-hp.gif”>

But I need to display an image which is present in the images folder in the BO installation directory. For that I am using

Then, it is unable to display the image.

nikhilnair (BOB member since 2014-08-08)

7

Hi Nikil,

Check this please.

Judia

judia (BOB member since 2008-06-24)

8

Hi Judia,

I have checked and the images are placed in the right folder.
It is the path which is mentioned in the parameter “Image directory” in WEBI processing server.

Still it is unable to get the images.

nikhilnair (BOB member since 2014-08-08)

9

Hi Nikhil,

The image must be either a JPG or GIF.
And some attributes should be modified as:
background-fill: bitmapAndColor;
background-type: box.

Please try and let me know.

Regards,
Judia

judia (BOB member since 2008-06-24)

10

Hi Judia,

There is no problem with the images format. They are JPG and GIF only.

When I write the code like below with servername and port then it is displaying the image and also the opendoc links are working fine:

=If([ObjectA]=1;"";"")

But since the server and port will be different for different environments and it needs to be migrated to client prod environment, I need a more generic code with relative path.
Therefore, I tried using BOIMG:// to give path for the images since it is the default path for images stored in BO.

The code now looks like this:
=If([ObjectA]=1;"";"")

With this code, the opendoc links are working fine but images are not loading.

nikhilnair (BOB member since 2014-08-08)

11

Hi Nikhil,

This is quite challenging and interesting task.
I have no idea how to write a generic code which would be applicable for any server.
But, I read a post as given below .

http://scn.sap.com/thread/3372909

This talks about the relative link in webi.
This will be helpful to you.

Cheers
Judia

judia (BOB member since 2008-06-24)

12

Hi Judia,

Thanks for sharing the post.
I tried to provide a relative link for my image path.
But when I give a relative path to that, the images are not showing.
When I am providing it with the servername and port, the images are working fine.

Regards,
Nikhil

nikhilnair (BOB member since 2014-08-08)

13

HI Nikhil,
I am sorry i am not able to help you as i havent used this fucntion before. If you find the solution. Please share it in Forum.

Cheers,
Judia

judia (BOB member since 2008-06-24)