SAP Knowledge Base Article - Public

2568577 - Cross domain Ad hoc report Employee Profile Domain and Continuos Performance Managementis is giving an error - Ad Hoc

Symptom

  • Cross domain Ad Hoc Report of Employee Profile Domain and Continuos Performance Management does not fetch records.
  • Cross Domain Ad Hoc 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 Workforce Analytics
  • Adhoc reports

Reproducing the Issue

Go To Ad Hoc 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 Ad Hoc 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

2494456 - Can't move colums in the report

2468661 - Cross domain Ad hoc - Application error to run, create or preview report

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

2459120 - Cross Domain Ad Hoc or ORD report is not respecting Role-Based Permissions (RBP) Cell Level Permission settings

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