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.

SAP SuccessFactors Succession & Development

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