Symptom
How Hide Duplicate Rows functionality work for Hidden Calculated columns in Online Report Designer?
Environment
SAP Successfactors
Online Report Designer
Cause
Prior b1605: Hidden calculated columns were considered when utilizing the Hide Duplicates functionality, so if hidden calculated columns had unique results, multiple records still appeared even when Hide Duplicates was enabled.
After b1605: Now only visible columns are considered when utilizing the Hide Duplicates functionality, so if hidden calculated columns have unique results, only distinct results appear when Hide Duplicates is enabled.
Resolution
1. Create a query in Detailed Reporting adding a calculated column with unique values.
2. Hide the Calculated column and Click Hide Duplicate Rows.
3. Query will hide all the available duplicate rows although the Hidden calculated column has unique values.
Keywords
Online Report Designer Hide Duplicate Rows Hidden Caculated Column WFA-6525 , KBA , LOD-SF-WFA , Workforce Analytics & Planning , How To