3585340 - How to import blank value in executive review - Compensation

This article describes how to import blank value in executive review.

SAP SuccessFactors Compensation

1. Login as Comp Admin and open Executive Review.
2. Select a template.
3. Find an editable string type column which has a value input for the employee.
4. Export Executive Review, remove the value in the column, save and import back to the system. Notice that there is no change after import.
5. In the import file, replace the value in the column with 1 blank space only, save and import back to the system. Notice that there is also no change after import.
6. In the import file, replace the value in the column with 2 blank spaces (or more), save and import back to the system. Notice that the value is now replaced and the worksheet shows 2 spaces in this column.
7. Despite these discrepancies, the Monitor Compensation Job indicates that the above three jobs are all completed and one entry was updated successfully.

This is system expected behavior.

• To change string fields to blank during an Executive Review import, add at least two spaces in the import file for the system to recognize it as a blank value.
• If you think this possibility would be useful on your business, you can share your ideas via Customer Influence Portal for our Product Management team to review it. Once you have submitted your idea, other customers and partners can vote for it and your votes help us to prioritize ideas that we will consider for upcoming product releases. You can refer to the kba here on how-to: KBA 2090228 - How to Submit Ideas for SAP SuccessFactors Products

SAP SuccessFactors Compensation, Executive Review, Import, String Field, Blank Value, Null Value, Unexpected Behavior, Two Spaces. , KBA , LOD-SF-CMP-EXR , Executive Review , How To