2470187 - Multiple records are appearing in Ad Hoc report of Employee Profile domain for a background element

SAP Knowledge Base Article - Public

2470187 - Multiple records are appearing in Ad Hoc report of Employee Profile domain for a background element

Symptom

  • Employee Profile domain's Ad Hoc Report is fetching multiple records for few employees for Internal Job History background element.
  • Employee Profile Ad Hoc Report is fetching multiple records for Internal Job History Background Element.
  • Employee Profile Ad Hoc Report is fetching multiple records for one employee for a Background Element.

Environment

  • Ad Hoc Report Builder (Employee Profile)

Reproducing the Issue

  • Create Ad Hoc Report of Employee Profile Domain
  • Select User Sys ID column 
  • Select all columns from any background element table. Here, background element table is - "Internal Job History B"
  • In the instance, navigate to Employee Profile for a specific user (Example User Sys ID - 1000101)
  • This user has one record in "Internal Job Histopry" portlet.

Data.png

  • In Ad Hoc Report, there are 3 records appearing for this user.

Ad Hoc Report.png

Cause

How to identify if the "Internal Job History B" is a background element:

  • Go to Admin Center > Employee Files > Configure Employee Files > Navigate to the specific view where this "Internal Job History" portlet is visible in the instance > In this scenario, Internal Job History is visible under "Employee Profile" view >
  • Scroll Down and find the background elements."Internal Job History B" portlet is a background element.

Configure Employee Files.png

Configure Employee Files - EP.png

Background Element - Internal Job History.png

How to find Background Element ID:

  • Login into Provisioning and download the Succession Data Model and find the background element id:
  • In Succession Data Model, Background Element ID of "Internal Job History B" is - "historicalWorkExperience2". Here is the part of configuration from data model:
    • <background-element id="historicalWorkExperience2" type-id="99">
    • <label>Internal Job History B</label>
    • <label xml:lang="en-GB">Internal Job History B</label>

How to download Background Information data:

  • Login into the instance > Go to Admin Center > Update User Information > Export Extended User Information > Select "Background Information" radio button under "Specify the type of Information You want to Export" > Export Extended data Only

Admin Center.png

  • Go Back to Admin Center > After 10 mins check if the file is available for Download > Once the file is available for download > Click on Download file button

Export Extended Data.png

  • Once the file is downloaded, open the file and check data for user ID - 1000101 in "historicalWorkExperience2" background element:

Background Data.png

  • In this file there are 3 records present for the user id - 1000101 that is why 3 records are appearing in Ad Hoc Report.

Resolution

  • Please have one record in Background Information file in case if you would like to fetch one record for each employee in ad hoc report for background element. 
  • Assistance regarding how to correct / modify/ import data in Background Information file falls outside of analytics support scope. 
  • If you need information on how to rectify the data issue in this file then please create new ticket with Employee Profile Team (Component: LOD-SF-EP)

Keywords

  • Ad Hoc Report
  • Employee Profile
  • Background Element
  • Background Information
  • Export Extended User Information
  • Internal Job History
  • Multiple Records in Ad Hoc Report
  • Incorrect Background Data appearing in Ad Hoc Report
, KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core all versions