Displaying Person Images in OTBI Analysis
Displaying Person Images in OTBI Analysis

 816 total views

In this article we will look into how to display Person spotlight images on the OBTI analysis.

Want to learn Fusion Technical tools? Checkout this article

In the previous article, we saw how to display person images in BI Publisher Report.

Let’s create an analysis based out of Workforce Management – Person Real Time subject area.

Navigate to Tools > Reports and Anlaytics > BI Catalog

Click on New > Analysis > select the Subject Area “Workforce Management – Person Real Time” and drag and drop the below fields from the folders.

Person Details from OTBI in fusion hcm otbi analytics person images
Person Details from OTBI

Now let’s modify the formula for the Person ID field by clicking on the settings icon beside that field and clicking “Edit Formula

Replace the field content with

'<img src="https://abcd-fa-ext.oracledemos.com//hcmUI/personImage?personId='||CAST("Worker"."Person ID" AS char)||'">'

Replace abcd-fa-ext.oracledemos.com with the actual application link on which you want to create the OTBI.

Adding formula to get the image displayed on OTBI in fusion hcm
Adding formula to get the image displayed on OTBI

Next we have to set the default format to display html.

Click on Image field Settings > Column Properties > Data Format tab

Change data format to html in otbi fusion hcm
Change data format to html

Check the Override checkbox and change format to html from text and click OK.

Now, let’s go to Results screen

We can see that images are getting displayed in OTBI fusion hcm
We can see that images are getting displayed in OTBI

This is how we implement the images functionality in OTBI Analytics.

Post P2T refresh, we need to change the POD link in the OTBI else the analysis refers to PROD images and might not show data in TEST POD.

Note: Even though the OTBI displays the images, when we export to PDF it doesn’t export the images. That’s the drawback of OTBI over BI Report where the images are also exported to PDF.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 2 Comments

  1. Santosh

    Glad you made it 😊

  2. Sricharan

    Yeah.. It’s the matter of time.. Thanks for suggesting idea and sample code for this article.

Leave a Reply