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

SAP Knowledge Base Article - Public

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

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:

  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

KB1.png

KB2.png

KB3.png

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