SAP Knowledge Base Article - Public

2615716 - Report returns less results than expected for a Cross Domain report

Symptom

  • A Table or Canvas - Detailed Reporting Live Data report shows less data than the expected count. E.g there are 16,000 employees, but only forms data for 14,000 is included in the result.
  • The report is a Cross Domain
  • When reporting using Single Domain, the report returns the expected number of results.

Environment

SAP SuccessFactors HXM Suite

Cause

The relationship scope used for the report query is Inner Join and there is no match at the other table/domain.

Resolution

  • Check the Relationship Scope used for the report, whether Left Outer Join or Inner Join.
  • Also check the fields/columns used to define the Join or Relationship Scope
  • Adjust the report configuration appropriately based on your findings.
  • If the report has information only on the second domain selected the report will not pull the information as there is no information to create the join.

Please refer to the below illustration of how Inner Join and Left Outer join works:

Join Explanation.png

 

within same module but different templates.png

Keywords

cross domain report, employee record missing, no data returned for cross domain, blank, report - table, ad hoc, adhoc, inner join, left outer join, ad hoc, live data, table, canvas, detailed reporting , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Suite all versions