SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • SAP SuccessFactors HXM Suite

Reproducing the Issue

  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
  6. The report will return two rows although you expect to have only one.

Username

Manager

Matrix Manager

Last Modified Date

U001

Carla Grant

Jaime Lopez

12/02/2015  17:05:38

U001

Carla Grant

Jaime Lopez

12/02/2015  17:05:41

Cause

  • No 'True' duplicates
  • Timestamp displayed as Date

Resolution

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.

Username

Manager

Matrix Manager

Last Modified Date

U001

Carla Grant

Jaime Lopez

12/02/2015  17:05:38

U001

Carla Grant

Jaime Lopez

12/02/2015  17:05:41

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:

Username

Manager

Matrix Manager

U001

Carla Grant

Jaime Lopez


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)

    dateTS.png

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

See Also

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

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions

Attachments

dateTS.png