SAP Knowledge Base Article - Public

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

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

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

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

Product

SAP SuccessFactors HXM Suite 2211