SAP Knowledge Base Article - Public

2774144 - Multiple Position Records Showing for One User in Succession Cross-Domain Report

Symptom

When creating a Cross-Domain report with a MDF Succession Management domain, several rows of position records are shown for one user.

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 Succession & Development

Reproducing the Issue

1. Create a Cross-Domain between one domain (For example: Employee Profile) and one of the Succession Management domains (For example: Succession by MDF Position)

cross_domain_set_up.jpg

2. Select columns from the first domain (For example: User ID) and select columns from the Succession domain (For example: Position Code)

cross_domain_columns.jpg

3. Select the join relationship between the two domains, by default it would join the domain where User Sys ID = USERS_SYS_ID

cross_domain_join.jpg

4. Save and generate the report, you will then see that multiple rows of position records shown for one user

cross_domain_preview_error.jpg

Cause

This issue is caused by the join relationship which was configured in the report definiton. The intial domain should join the user id to the Position Incumbent id to get a one to one relationship between the user data and the position data

Resolution

1. Edit the join relationship from User Sys ID = USERS_SYS_ID to User Sys ID = Incumbent User ID

cross_domain_join_2.jpg

2. Save and generate the report, you will then see a one to one relationship between the user data and position data

cross_domain_preview_correct.jpg

Keywords

Succession, Ad-Hoc, Report, Builder, Online, Report, Designer, ORD, Detailed, Reporting, Inclusive, Nomination, History, Talent, Pool, Metadata, Framework, Employee, Central, Successor , KBA , LOD-SF-SCM-REP , Reporting and Data Imports Exports , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors Succession & Development all versions