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:
- Invoice images are stored on a separate server
- Click on an image link to display invoice image
- 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.
Steps to Create an Image Link
Change the column properties of the column that contains the attachment link text to data type HTML.
Edit the “Attachment Link” column to something similar to the below.
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.
The highlighted piece of the code opens the image in a separate browser window.
The highlighted piece for this code puts replaces the actually 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.