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
- Stories in People Analytics
- Performance Management
- Competency
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
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
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
Attachments
Pasted image.png |