Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Report Employee Photo in Custom Dashboard
Summary
Is there a way to display an employee photo in a custom dashboard?
Content
We have a custom Talent Profile dashboard and I am wondering if there is a way to pull employee photos into the dashboard so they can be printed on the report?
Thank you!
Brenda
Comments
-
Hi Brenda,
To display employee picture in the dashboard, you have to store all your employee pictures in a web folder and should accessible using the https url.
Example : https://pbs.twimg.com/profile_images/800840075311333376/515GX-Cc.jpg
Store the employee picture with employee id.(Ex: ID001.jpg,ID002.jpg)
Use the below syntax to create a new formula column in your analysis report and select the HTML values in the Data Format (refer the attached screenshot).
Formula Sample : '<img src="https://pbs.twimg.com/profile_images/800840075311333376/' ||TRIM(CAST("Employee_ID_Field" AS CHAR)) || '.jpg">'
Let me know if this resolve your issue.
MANOJ
Dynasoft Synergy
0 -
Hi Brenda,
To display employee picture in the dashboard, you have to store all your employee pictures in a web folder and should accessible using the https url.
Example : https://pbs.twimg.com/profile_images/800840075311333376/515GX-Cc.jpg
Store the employee picture with employee id.(Ex: ID001.jpg,ID002.jpg)
Use the below syntax to create a new formula column in your analysis report and select the HTML values in the Data Format (refer the attached screenshot).
Formula Sample : '<img src="https://pbs.twimg.com/profile_images/800840075311333376/' ||TRIM(CAST("Employee_ID_Field" AS CHAR)) || '.jpg">'
Let me know if this resolve your issue.
MANOJ
Dynasoft Synergy
0 -
Hi Manoj,
Thank you for your response. I'm not sure if my company will go for storing photos that way, but this solution is a definite possibility. I have moved in the direction of trying to extract the employee photos directly from the table using a DM. I am hoping to be able to show that in a report that can be pulled into the dashboard. Have you been able to get that method working? Here is the SQL from my DM, but I still haven't been able to get the image to show in the report.
select per_all.person_number,
per_name.last_name,
per_name.first_name,
per_i.IMAGE_NAME,
per_i.IMAGE
from fusion.PER_IMAGES per_i,
fusion.PER_ALL_PEOPLE_F per_all,
fusion.PER_PERSON_NAMES_F_V per_name
where upper(PRIMARY_FLAG) = 'Y'
and per_i.PERSON_ID = per_all.PERSON_ID
and per_all.PERSON_ID = per_name.PERSON_ID
and per_name.name_type = 'GLOBAL'Thank you!
Brenda
0 -
Hi Brenda,
Please send us sample data (dummy data) for your SQL. This will help us to understand in which format the image data is stored in the database. Based on that we can suggest if there is a solution/workaround to resolve the issue.
MANOJ
Dynasoft Synergy
0 -
Hi Manoj,
I'm Brenda's colleague from Hungary and work as HRIS.
How can we upload all our employee photos to the WEB folder and which folder?
do we need a special tool or script for this (I didn't find any options/solution) ?
Thanks
Sandor
0