Symptom
When creating reports in Story Report for Interview Scheduling, multiple entries are created per candidate.
"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 Recruiting Management
Reproducing the Issue
- Navigate to Admin Center > Reporting > Story Report.
- Create a Story Report for reporting on interview scheduling fields.
- Multiple entries are created per candidate.
Cause
The reason of the duplications is because there are multiple interviewers. There will be 1 line for each interviewer, even if the interviewer name is not selected for the display making the “illusion” of identical lines.
Resolution
As designed, Story report builds the JOINs between tables is “left join” which means taking all records available, regardless of the display options. In order to identify the differences of the entries, enable "Display Name" column. This will display the name of the Interviewers.
See Also
3528660 - Available Recruiting Data Schemas in Story Reports - Recruiting Management
Keywords
People Analytics, Story Report, Interview Scheduling, Multiple Applicants, Job Requisition, Reporting Issue, Inconsistencies, Multiples Entries, Duplicate Story Report , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem