Symptom
The Matrix Grid Report shows correct data on the UI, but the Excel export contains different values for the Talent Flags/Icon fields (Example: "risk of loss" and "impact of loss" fields.).
Environment
SAP SuccessFactors Succession Management
Reproducing the Issue
- Open the Matrix Grid Report and review the on-screen Talent Flag/Icon values.
- Export the matrix grid data to Excel.
- Compare the exported values against the ones from the UI and observe that the values do not match.
Cause
The labels for the icons are not aligned between the locale and the default values for the Excel export under the Matrix grid report icon configuration page.
Resolution
Update labels for the icons in the default values for the Excel export under the Matrix grid report icon configuration page. Follow the steps below:
- Go to the "Matrix grid report icon configuration" page.
- Select the affected field
- Click on Take Action > Edit
- Change Language to Default
- Update the labels for the column "Alternate text for Excel export"
- Save the changes.
- Re-export the matrix grid to Excel and verify that the exported values now match the on-screen grid.
See Also
Keywords
matrix grid, performance-potential, 9-box, excel export, mismatch, risk of loss, impact of loss, labels, icon configuration, export mismatch, wrong box, unrated, language label, succession, development , KBA , LOD-SF-SCM-MXG , Matrix Grid Reports (9 Box) , Problem
SAP Knowledge Base Article - Public