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

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