3524371 - Duplicate Result on Performance Form Story Reports due to Competency Object

When joining Competency table in Performance form Story reports the results are getting duplicated

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HXM Suite
  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    • Stories in People Analytics
      • Query Designer - Filter, Calculated Column, Params
  • Performance Management
    • Competency

1. In Story reports query designer (DataSource), add the tables from Performance Management (Form Template > Form).
2. Join Competency table and columns like Competency name and Competency rating
3. Click Preview Query
- Multiple rows display for every unique record

Duplicate rows are due to several Other rating records from the PM Form
If you add Other rating owner User ID column in the query you will get distinct values for this field

Work around:
Add this filter condition in (Advanced Filtering) in the query designer
Manager user id (from Form Subject) equals to Other rating owner userid (from Competency) - assuming that the manager is the official rating owner of the form

3412790 - Duplicate records in Story Reports

Performance Management, Competency, Duplicate, Multiple Rows, Stories, People Analytics, Embedded Analytics, Report, Report Center , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To