Symptom
- an Advanced Reporting query has multiple Job Relationships objects added (eg. HR Manager [Job Relationships], Matrix Manager [Job Relationships (2)] etc)
- try to add First Name and Last Name from Job Relations Global Job Information but it is only joining to one of the Job Relationships objects
Environment
Advanced Reporting for EC (Relams)
All Datacenters
Cause
- each Job Relationships object has to be activated individually (all other Job Relationship objects will therefore be inactive while one is active)
Resolution
To get the Job Relationships Name:
- Go to query and select Objects Tab
- Select the Job Relationships Object which requires First Name and Last Name
- Select the Column icon in the right corner
- Select the “Eye” icon at the top (which will activate that path)
- In the top section, Navigate to Global Job Information > Job Relationships > Job Relation > Job Relation Global Job Information > Job Relation First Name/Job Relation Last Name
- Drag the field onto the bottom canvas
Repeat above for each Job Relationships Object that has been added to the query
Keywords
KBA , LOD-SF-ANA-ORD , Online Report Designer , How To
Product
SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors Workforce Analytics 1705 ; SAP SuccessFactors Workforce Analytics 1708