There are many use cases when and why a user would want to view an image in reference to a particular piece of data in OBIEE. The example below demonstrates how to create an HTML image link.

The business users wanted to be able to review invoices that were assigned voucher numbers. If a voucher was available the user could click on an image link and the invoice image would display in a separate window.

The Requirements for the image link:

  1. Invoice images are stored on a separate server
  2. Click on an image link to display invoice image
  3. When image link is clicked, invoice image opens in new window

The final result is seen below. Each row has its own unique attachment link that is hidden behind the image in the attachment column on the far right.

    Using an HTML image link in OBIEE

Steps to Create an Image Link

Change the column properties of the column that contains the attachment link text to data type HTML.

OBIEE HTML image link - Change column properties

Edit the “Attachment Link” column to something similar to the below.

OBIEE image link - edit the attachment link

Let’s break down the pieces of this HTML code to understand what each piece is accomplishing.

The highlighted section dynamically calls the individual link for each unique document link row.

OBIEE - dynamically call image link

The highlighted piece of the code opens the image in a separate browser window.

OBIEE - open image link in separate browser window

The highlighted piece for this code puts replaces the actually document link with an image link.

OBIEE - replacing document link with an image link

Free eBook Download

In the eBook “Having a Conversation with Data”, learn what the current BI infrastructure has been and associated challenges with the traditional approach. How important the user experience is in order to best maximize data’s value (think visualizations!!) to your organization and how to gain a competitive advantage with modern analytics platforms.