SAP Knowledge Base Article - Public

2739954 - Report not pulling current information, and remains the previous record information - Ad Hoc Reporting

Symptom

  • Report not pulling current information, and remains the previous record information.
  • Changing label on MDF Object does not reflect on Ad Hoc Reporting - Person and Employment (As of Date) domain.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

  • SAP SuccessFactors Workforce Analytics
  • Ad Hoc Reporting - Person and Employment (As of Date) domain
  • SAP SuccessFactors Employee Central

Reproducing the Issue

See below example:

  1. Go to Admin Center
  2. Search/Find Manage Data
  3. Filter for Department (example)
  4. Create a new record and change a field effective as or after today's date
    obj.png
  5. Go to Report/Reporting
  6. Create New
  7. Select Report - Table
  8. Select Person and Employment (As of Date) domain
  9. Select People Scope & the required columns.
    report.png

 

Cause

This is caused because the Ad Hoc Reporting - Person and Employment (As of Date) domain pulls data from Job History of the employee, if there is no record on Job Information after the effective date of the object change (e.g. Department - 01/01/2019) Ad hoc will show data from the last Job History record.

Resolution

In order to pull data from the new data on the object (e.g. Department) then is needed to insert a new record on the Job Information of the employees after the object change.

E.g.:

  1. Go to Employee Profile
  2. Find Job Infomation section
  3. Click on the Clock
  4. Click on Insert New Record (after 01/01/2019 as above example)

Keywords

Report not pulling correct current data today date currently object appearing showing previous show MDF custom foundation adhoc label change , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors HXM Suite all versions