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

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:

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.

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