SAP Knowledge Base Article - Public

2250286 - Duplicate Records in Canvas Report - Advanced Reporting - Data Validated

Symptom

There are one or more duplicate Records in Canvas / ORD reports with Advanced Reporting Data source

Environment

  • SAP SuccessFactors HXM Suite
    • Report - Canvas: Advanced reporting

Cause

System Limitation - No option to Enable Distinct in Advanced Reporting

Resolution

  • Advanced Reporting will fetch duplicates If any field in any of the tables used in the query has different data for the records displayed.
  • This would be the case, even if the aforementioned field has not been used in the query.
  • To remove these duplicates, we would have to identify this field and apply filters to it to exclude unwanted entries.

The best approach to do this would be:

  1. Make a Copy of the Query / Report under concern.
  2. Add a filter to just include an example user / record that results in duplicates.
    (This reduces the query’s run time and reduces the refresh interval between every change made)
  3. Isolate the problematic table by removing the existing tables one by one.
  4. Once identified, retain this table and remove as many of the other tables as possible.
    • We are trying to replicate the duplicates issue with minimal tables / fields.
    • You could also export the data in XLS / XLSX format and use external tools like Microsoft Excel to identify duplicates
  5. Include all the fields from the table identified in step 3.
  6. Review the results and identify the fields that have different values.
  7. Use Filters or the ‘Edit Restrictions’ option for the particular table to include only the required data identified in Step 6.
  8. if you see different entries for date fields like "Effective Dates", "Start Date", "End Date", reconsider the date options applied in the report.
    More details on date options - 2368375 - How to Set Up and Use Date Options in Advanced Reporting

If you feel 'Enable Distinct' is a critical functionality for Advanced Reporting, we request you to submit an enhancement request for the same.
2090228 - How to submit enhancement requests for SAP SuccessFactors products
This will allow other customers to vote up and thereby express their interest on the same.
Our Product management teams review enhancement requests regularly and implement them if and when feasible.

See Also

2815667 - Duplicate records in Advanced reporting for Personal and Global Information tables - Data Issue

Keywords

Advanced, Reporting, duplicate, row, rows, record, records, line, lines, multiple, users, data, corrupt, sync, out, of, REALMS , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC-ROD , Advanced Reporting (Employee Central ODS/ORD) , Problem

Product

SAP SuccessFactors HXM Suite all versions