Symptom
You create an Online Report Designer (Canvas) / Report - Canvas report with Detailed Reporting > Live Data as the data source.
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 describes how you can hide duplicates for Detailed Reports from the Online Report Designer (Canvas).
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
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 follows:
- From the Detailed report query/report > Edit > Select Hide Duplicate Rows
- When selected, duplicate rows will automatically be hidden from view.
- You can toggle between showing and hiding duplicate rows by clicking the checkmark next to Hide Duplicate Rows on the menu.
If Report Center is enabled it is required to edit the query of the report to find the query section. See steps below:
- Select the component within the query;
- Select the Edit on the query > "Hide Duplicate Rows"
Note:
- It's not possible to get a single row if any column has distinct data, the only way to have only one row is by deleting the columns that are causing it (Detailed and adhoc/table reporting). If you feel this behavior should be changed, please submit an enhancement request: 2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products
- The hide duplicates function is not available for Advanced Reporting for Employee Central queries. The functionality is available only for Live Data (Tables data) source only.
- For Table report the function is called Enable Distinct as described in the KBA 2283071 - How to remove report Duplicates with the Enable Distinct Feature in Ad Hoc Reports
Keywords
Duplicate Rows, hide duplicates, detailed reporting, Enable Distinct, Live Data, Detailed Reporting, Report - Canvas, Canvas, ORD , KBA , duplicate rows , detailed reporting , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To