SAP Knowledge Base Article - Public

3041807 - How to Hide Duplicates in Story [People Analytics]

Symptom

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

SAP SuccessFactors HXM Suite all versions