SAP Knowledge Base Article - Public

3286205 - Duplicate records in Advance report created on Time Management object


When user runs report on Time Management objects, can see there are duplicates in output.


SAP SuccessFactors HXM Suite

  • Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
    •  Online Report Designer
      • Advance Reporting

Reproducing the Issue

  1. Login into instance 
  2. Create a report on Time management objects (Time Account, Time Account Detail, Employee Time)
  3. Can see there are duplicate records in output


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.


Time, Account, Detail, Employee, Time, Management, Object, endDate, Date, bookingDate, Equals, Duplicate, Advance, Report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite 2211