SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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

Reproducing the Issue

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

Cause

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

Resolution

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

See Also

3412790 - Duplicate records in Story Reports

Keywords

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

Product

SAP SuccessFactors HCM Core 2405

Attachments

Pasted image.png