Symptom
When user runs report on Time Management objects, can see there are duplicates in output.
Environment
SAP SuccessFactors HXM Suite
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
- Online Report Designer
- Advance Reporting
- Online Report Designer
Reproducing the Issue
- Login into instance
- Create a report on Time management objects (Time Account, Time Account Detail, Employee Time)
- Can see there are duplicate records in output
Resolution
Suppose if a user takes leave for 3 days starting from Today, in report output it will show 3 entries.
This will be fetched from field bookingDate from Object Time Account Detail
Enddate field from Employee Time object fetches end date of these leaves that is Today+3
To reduce Duplicates {Ideally, they are not duplicates it fetches one record for all the 3 days leaves applied}
We need to apply filter bookingDate Equals to Enddate, out of the three rows appearing in output this condition will be satisfied for only one row, so in output we get only one row.
Keywords
Time, Account, Detail, Employee, Time, Management, Object, endDate, Date, bookingDate, Equals, Duplicate, Advance, Report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem