SAP Knowledge Base Article - Public

2965425 - Duplicate records even using table filter to restrict the query - Advanced Reporting


Advanced Reporting is displaying multiple records even using the table filter to restrict the query to specific values

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

Reproducing the Issue

  1. Create a report in Advanced Reporting
  2. Select Foundation Object Pay Grade
  3. Add the Pay Range object to the query as well

  4. Note that in the result there are multiple records for the same pay grade e.g. Salary Grade 01

  5. Go back to the Objects tab
  6. Click on the blue box next to Pay Range object
  7. Apply a table filter to one pay rage e.g. New Zealand Salary Range 01

  8. Check the Results
  9. The expectation was to remove the other rows not in New Zealand Salary Range 01
  10. But the current behavior is to keep the rows with a blank cell


This is an expected behavior when two tables have a system generated relationship object between them e.g."View Generic Relationship" or "Associations":

The workaround is to change the Join between the object on the right and the relationship object to Inner:


Please note that if Inner join is set and the object on the left does not find any matching values on the table filter from the right object, the result will be blank for both tables.

See Also

2545465 - How to convert multiple row data in single row in Advanced Reporting (transpose)


Advanced Reporting multiple duplicate records table filter restrict query values report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To


SAP SuccessFactors HCM suite all versions


Pasted image.png