/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
How to Hide Duplicates in Story
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
- People Analytics
- Story Reports
Resolution
We call a row a duplicate only if all the values are same in more than one row.
Getting duplicate rows in a list report is very common. This could be expected if we query a database table that holds the same values for a user up to certain fields (say Set A) and different values in remaining fields (say Set B). Now, if we just add fields from set A in a report, it will output the same values for a user in multiple rows.
In Stories, we can easily hide the duplicate rows by using Aggregated List Type
See Also
See more details on Our portal: People Analytics – What it offers distinctively?
Keywords
SAC, People, Analytics, Story, Reports, Hide, Duplicates, Enable, Distinct , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To
Product
Attachments
| Pasted image.png |
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)