SAP Knowledge Base Article - Public

2145834 - Multiple rows are still shown in the Ad Hoc report even if the Distinct Rows function is enabled

Symptom

You create an Ad Hoc report based on Single/Cross domain or Multi Dataset and tick the Enable Distinct checkbox however when you run the report you still see multiple rows for a specific user or field although you would expect to see only a single row.

Environment

  • SuccessFactors HCM Core
  • Ad Hoc report

Reproducing the Issue

  1. Login to the instance
  2. Select Reporting > Analytics > Ad Hoc Reports
  3. Create an Ad Hoc 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

The report behaviour is as designed.

Resolution

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) from the report in order to hide the additional row.

For example: 

Username

Manager

Matrix Manager

U001

Carla Grant

Jaime Lopez

Keywords

KBA , multiple rows , duplicates , distinct rows , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To

Product

SAP SuccessFactors HCM Core all versions