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)
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
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
2. Save and generate the report, you will then see a one to one relationship between the user data and position data
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