2494846 - How to find "Enable distinct" option when creating ORD reports ?

SAP Knowledge Base Article - Public

2494846 - How to find "Enable distinct" option when creating ORD reports ?

Symptom

How to find "Enable distinct" option when creating ORD reports ?

Environment

  • SAP SuccessFactors HCM Core
  • Online Report Designer / Live Data

Reproducing the Issue

You create an ORD report and would like to find the option "Enable distinct" to remove duplicate rows

Cause

This option is not called "Enable distinct" but "Hide Duplicate Rows"

Resolution

Do the following

  1. Go to Analytics
  2. Detailed Reporting
  3. Create or open an existing query 
  4. Select Edit 
  5. Select "Hide Duplicate Rows" as seen below

Note that this option is not available for the "Advanced Reporting"

Hide duplicate.png

Keywords

  • Hide duplicate row
  • Enable Distinct
  • ORD
  • Online Report Designer
  • Remove duplicate data
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core 1705