SAP Knowledge Base Article - Public

2283071 - How to remove report Duplicates with the Enable Distinct Feature in Ad Hoc Reports

Symptom

You run an Ad Hoc report and get duplicates in the Ad Hoc Reports result.

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Reports

Reproducing the Issue

  1. Create an Ad Hoc Report from any Domain ( Example: Performance Management, Employee  Profile etc)
  2. Select the Columns from Column tab
  3. You are seeing the duplicates in the report for the selected columns

Cause

There can be multiple reason for duplicates in Adhoc such as missing (not including) a column that has unique value for the set of columns you have selected.

Resolution

  1. We have provided a feature called "Enable Distinct" to remove the duplicates in Adhoc report.
  2. Edit Report and go to Column tab.
  3. You will see a checkbox called "Enable Distinct". Once you check that and save the report, duplicates will be removed from the Report.

2018-09-17_13-56-35.png

Keywords

Adhoc Reports Duplicates records Enable Distinct , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions