Skip to Content
Technical Articles
Author's profile photo Xavier Le Garrec

Understanding the Executive Review Import feature

The Executive Review import feature is a very useful feature of the compensation module of SuccessFactors for system administrators.

Being able to mass adjust recommendations for a selected group of employees (by filtering on them using the enhanced executive review filters) can be a huge time saver for Admins during a review cycle.

In this recording I cover the following aspects of this feature :

  • How it works (demo).
  • What to pay attention to when using it :
    • Covered in recording below : hard custom validation (“error”) need to be changed to “warning” in Design Worksheet before the import (covered in the recording below).
    • Not covered in recording below : manual performance rating column (standard column with id= compRating) must be removed from Design Worksheet before import then added back afterwards because any unrated value in that column will cause the import to fail / which is why we may have a situation where the import works on a small group of users but not on the full scope / which is likely to have “unrated” ratings in that column).
  • How to turn it on if you don’t have it on already.

 

 

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo laura gyselbrecht
      laura gyselbrecht

      Hi Xavier, very useful! Additional questions here: the yellow columns in the export file are hard coded as I understand, but what defines if a column is importable or not? Thanks, Laura

      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec
      Blog Post Author

      Hi laura gyselbrecht

      a column becomes yellow on that first export if it is editable on the worksheet (read-only = No in Design Worksheet).'

      I came across this case the other day : a customer had willingly hidden the amount recommendation box for the standard merit field and only kept the % editable for planners. Yet they wanted to use exec review import which only works on the amount (we can't import % and have it update the amount, we must use amounts). All we had to do was temporarily switch back the setting "Percent or Amount" for that column to be equal to "Show both percent and amount", then quickly export-reimport, then set the setting back to its original value of "Show percent only". It worked fine on live worksheets.

      All the best,

      Xavier

      Author's profile photo laura gyselbrecht
      laura gyselbrecht

      Hi Xavier,

      Nice tip, thanks a lot for sharing!

      Best, Laura

      Author's profile photo Tatiana Caraiman
      Tatiana Caraiman

      Hi Xavier,

      Do you know if the same applies to Hard Stop on guidelines, as in the case of hard custom validation?

      I have hard limit on the guideline and if I try to import in the executive review values that are outside of the guidelines I get the same error.

      Isn't it possible just to get the correct values uploaded and those that don't follow the rule to be skipped?

      Thank you.

      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec
      Blog Post Author

      Hi Tatiana Caraiman

      I wasn't able to replicate the issue you are having in my environment, please see the recording below where I made 2 edits, one for someone with value outside hard guideline max (50% in this template) and another one within the guideline. Only the one outside guideline max was skipped, the other one was correctly updated.

      https://youtu.be/g_itPkaxePA

      All the best,

      Xavier

       

      Author's profile photo Tatiana Caraiman
      Tatiana Caraiman

      Thank you, Xavier. I guess I will check it with the Support.

      Regards,

      Tatiana

      Author's profile photo Tatiana Caraiman
      Tatiana Caraiman

      Hi Xavier,

      I have an update:

      Yes, it is expected when you exceed guideline in the import file even for one employee, the whole import will fail for those who belong to the same worksheet. It is an expected behavior.

      If I exceed the guideline for an employee from one worksheet but I am within the guideline for an employee from another worksheet, then only the one who isn't within the guideline will fail.

      Example, I have exceeded the guideline for Employee X but the import failed for Employee Y as well, because both employees belong to the same worksheet.