SAP Knowledge Base Article - Public

3101609 - Duplicate records in advance report due to user having multiple records with 'End Date' in future


A user having multiple records with 'End Date' in Future is resulting in duplicates in advance reporting.


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 canvas report
  3. Include Effective Start and End Date fields
  4. In results section we can see there are multiple records for a user (Effective End Date is in future)


This occurs when there are multiple records, for a user, ending in future.


  1. In Advanced Report > Calculated Columns > create an aggregated calculated column on Start date from the object where Multiple records are end dated in Future, by selecting Max Function
  2. Apply filter on start date by selecting Aggregated calculated column under Field comparison
  3. In the output we can see only record with the latest start date for that particular user


Multiple, Records, records, dated, end, start, Aggregated, calculated, column, Max, Function, Field, Comparison, Future , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite 2105