SAP Knowledge Base Article - Public

2280253 - Hide Duplicate Rows function in Online Report Designer (ORD)

Symptom

You create an Online Report Designer (ORD) report but when you run the report you see multiple rows for a specific user or field although you want to see only a single row.

This document will describe how you can hide duplicates for Detailed Reports from the Online Report Designer (ORD).

"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 Workforce Analytics
  • Detailed reporting

Resolution

For Detailed Reporting queries (live data) you can use the hide duplicate rows function to remove the rows containing the exact same data as follow:

  1. From the ORD query/report > Edit > Select Hide Duplicate Rows
  2. When selected, duplicate rows will automatically be hidden from view.
  3. You can toggle between showing and hiding duplicate rows by clicking the checkmark next to Hide Duplicate Rows on the menu.

Hide dup.jpg

With Hide dup.jpg

 

If the Report Center is enabled it is required to edit the query of the report to find the query section. See steps below:

  1. Select the component within the query;
    2018-10-29_20-47-20.png

  2. Select the Edit on the query > "Hide Duplicate Rows"
    2018-10-29_20-46-05.png

Note:

 

Keywords

Duplicate Rows, hide duplicates, detailed reporting , KBA , detailed reporting , duplicate rows , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To

Product

SAP SuccessFactors Workforce Analytics all versions