SAP Knowledge Base Article - Public

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


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.


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)


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


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


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



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


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


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



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


SAP SuccessFactors Succession & Development all versions