2145834 - Table and Detailed Reports Show Multiple Rows Per User Even with Enable Distinct/Hide Duplicate Rows Option Enabled

Multiple rows are still shown in the Table and Detailed Reports show multiple rows per user even with Enable Distinct/Hide Duplicate Rows option Enabled

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HXM Suite
• Table Reports
• Canvas Reports Detailed Reporting

1. Login to the instance
2. Go to Report Center
3. Create a new table or detailed report
4. For this example, add the Username, Manager, Matrix Manager and Last Modified Date field to the column
5. Tick the Enable Distinct (for Table report) or Hide Duplicate Rows (for Detailed report) check-box
6. The report will return two rows although you expect to have only one.

• No 'True' duplicates
• Timestamp displayed as Date

No 'True' duplicates

The Distinct Rows function will apply only where the content of the rows, shown in the report, is exactly the same (duplicates).

In case the content of the rows is different for any column/fields the row will not be hidden.

In this example, we can see that the time for the Last Modified Date field is not exactly the same. For this reason multiple rows are shown.

In such case you will need to remove the respective column (Last Modified Date in this example) from the report to hide the additional row.

For example:

Timestamp displayed as Date

Table/Detailed reports can display Timestamp data as dates or as timestamps
Because of this, if a specific timestamp column has different timestamps from the same date, but has been configured to be displayed as a date column, it will display the same date in all the occurrences (rows).
This is also an expected behaviour.
You could change the behaviour of the columns, to display the data as timestamps:

Table report:

1. Edit the report under concern
2. Navigate to the 'Configuration' pill
3. Click 'DataType Configuration'
4. For the desired column, select 'Timestamp' from the drop-down (would say 'Date' by default)
   
   

Detailed Reporting:

1. Edit Query
2. Edit
3. Column Formating
4. For the desired column, select 'Timestamp' from the drop-down

Case sensitive Text

Text processing is always case sensitive for Databases.
Hence, if two rows have the same text but in different casing (Upper case vs Lower case), they would be considered as unique entries by the reporting system.
However, the 'Remove Duplicates' option in mist Spreadsheet programs are insensitive towards casing and would flag such instances as duplicates.

This is expected behaviour. If you wish to avoid such results, you could consider streamlining your data input methods or would have to use external programs to remove such pseudo-duplicates

KB article 2283071 - Duplicated Rows in Adhoc Reporting/Report Table

sf, success factors, ad hoc, center, duplicate, per, enable, distinct, not working, case, upper, lower , KBA , duplicates , distinct rows , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To