2335379 - Online Report Designer - Hide Duplicate Rows functionality for Hidden Calculated columns

SAP Knowledge Base Article - Public

2335379 - Online Report Designer - Hide Duplicate Rows functionality for Hidden Calculated columns

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.

1.PNG

 

2. Hide the Calculated column and Click Hide Duplicate Rows.

2.PNG

 

3. Query will hide all the available duplicate rows although the Hidden calculated column has unique values.

3.PNG

Keywords

Online Report Designer Hide Duplicate Rows Hidden Caculated Column WFA-6525   , KBA , LOD-SF-WFA , Workforce Analytics & Planning , How To

Product

SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608