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

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.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Core

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

Advanced reporting, Canvas, ORD, report, job relationship, manager, firt name, last name. , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors HCM Core 1602 ; SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Core 1711 ; SAP SuccessFactors HCM Core 1802 ; SAP SuccessFactors HCM Core 1805 ; SAP SuccessFactors HCM Core 1808 ; SAP SuccessFactors HCM Core 1811 ; SAP SuccessFactors HCM Core 1902 ; SAP SuccessFactors HCM Core 1905 ; SAP SuccessFactors HCM Core 1908 ; SAP SuccessFactors HCM Core 2405 ; SAP SuccessFactors HCM Core 2411 ; SAP SuccessFactors HCM Core 2505 ; SAP SuccessFactors HXM Core 1911 ; SAP SuccessFactors HXM Core 2005 ; SAP SuccessFactors HXM Core 2011 ; SAP SuccessFactors HXM Core 2105 ; SAP SuccessFactors HXM Core 2111 ; SAP SuccessFactors HXM Core 2211 ; SAP SuccessFactors HXM Core 2305 ; SAP SuccessFactors HXM Core 2311 ; SAP SuccessFactors HXM Suite Core 2205 ; SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1411 ; SuccessFactors HCM Core 1502 ; SuccessFactors HCM Core 1505 ; SuccessFactors HCM Core 1508