SAP Knowledge Base Article - Public

2568577 - Cross domain Table report Employee Profile Domain and Continuos Performance Management is giving an error - Table Reports

Symptom

  • Cross domain Table Report of Employee Profile Domain and Continuos Performance Management does not fetch records.
  • Cross Domain Table Report of EP and Continuos Performance Management is not fetching expected result when join is present between "Employee: User Sys ID" and "Objective: Objective ID".

Environment

  • SAP SuccessFactors HXM Suite
  • Table reports

Reproducing the Issue

Go to Report Center > Table Report > Create > Select Cross Domain > Choose Continuos Performance Management

Add Employee Profile Domain
Select few columns from "Continuos Performance Management" module. 
Select few columns from "Employee Information" table under Employee Profile module
Under "Relationship" tab select as below:

    • "Objective: Objective ID" Inner Join "Employee: User Sys ID"

OR

    • "Objective: Objective ID" Left Outer Join "Employee: User Sys ID"

Cause

This is data issue which does not satisfy the criteria present under Relationship tab in Table Report.

Resolution

It is required to select a relationship that will bring the same information that is available on both domains. For example employee ID as below:

2017-11-22_14-20-53.png

See Also

2433258 - Cross domain Ad Hoc Report of Recruiting V2 and Employee Profile Domain does not fetch records

Keywords

Adhoc - Cross Domain - Birt error - Relationship , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors Workforce Analytics all versions