SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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

Resolution

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:

Result:

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)

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png