SAP Knowledge Base Article - Public

2497372 - How to get First Name and Last Name of multiple Job Relationships eg. HR Manager and Matrix Manager


  • 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


Advanced Reporting for EC (Relams)

All Datacenters


  • each Job Relationships object has to be activated individually (all other Job Relationship objects will therefore be inactive while one is active)


To get the Job Relationships Name:

  1. Go to query and select Objects Tab
  2. Select the Job Relationships Object which requires First Name and Last Name
  3. Select the Column icon in the right corner
  4. Select the “Eye” icon at the top (which will activate that path)
  5. 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
  6. Drag the field onto the bottom canvas

Repeat above for each Job Relationships Object that has been added to the query





KBA , LOD-SF-ANA-ORD , Online Report Designer , How To


SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors Workforce Analytics 1705 ; SAP SuccessFactors Workforce Analytics 1708