Tag Archives: Executive Review

SuccessFactors Compensation – Executive Review Export / Import Functionality

Cloud, Compensation, Executive Review, SAP Consulting, SuccessFactors, Talent Management, Variable Pay, , , , , , ,

In traditional annual compensation (focal) processes, performing work offline is typically frowned upon by compensation and HR professionals. Whether it be for merit, bonus, or equity recommendations, discretionary increases and awards should be carefully considered by planning managers based on (typically) performance and market factors (e.g. compa-ratio).  However, there are circumstances where an export and import of recommendations could come into handy during an annual (or periodic) compensation process:

  1. A group of employees (e.g. customer service reps, manufacturing workers, etc) who –  either unionized or non-unionized – need a common increase. This may or may not be driven off a bargaining agreement.
  2. A legal requirement for a country. For example, in France or Spain, where a general or mandatory increase may have been decided by the government
  3. A COLA (cost of living adjustment) that needs to be applied to a particular group of employees by geozone or location.

In the cases above, SuccessFactors Compensation does provide functionality for planners to export and then subsequently import recommendations.

Below are the technical details on how to turn it on and how to use it in a Production scenario.

Assuming you have the permissions to do so, you can turn on the import functionality in the Executive Review by going to Admin Center > Compensation Home > Actions for All Plans > Compensation Settings

Company Settings within Compensation Home
Company Settings within Compensation Home

Select the option “Enable Compensation Excel Offline Edit”.  As the help states, when this setting is checked, compensation planners may download worksheet values to excel, enter recommendations, and then import them back into the system.

Compensation worksheet with Import and Export buttons

When clicking on the Export button (with the Import functionality enabled), the following pop-up is available. You should select the checkbox to indicate that the recommendations will be imported back into the tool. You can download in either Excel or CSV format.

Worksheet Download in Excel – Ready for Input

 

The important thing to note here is that:

  1. the planner should NOT insert or change ANY columns on this Excel , except to update the recommendations (input) in Yellow.  These are the only fields that the system will use when it gets uploaded
  2. the downloaded document does not contain any formulas

The import process is straight-forward.  When the planner has completed their update of the recommendations/awards in yellow, use the Import button to upload the updated records.

Importing Compensation Recommendations

 

Please note the two options at the bottom of the pop-up box:

  1. Send email notification to original planner/manager of the affected compensation form
  2. Send email notification to current reviewer of the affected compensation form

The first email (as of b1705 release) has the first option automatically checked. Be careful to uncheck that if you don’t want emails to be sent.

A current limitation with the functionality is that this functionality only works within the Compensation module and not within the Variable Pay module.  Still TBD on whether or not this will be added to the roadmap.  Those familiar with SuccessFactors Variable Pay know that it is a very different animal.

The other big limitation is that currently (as of b1705 release), there is no way to provide this Import functionality via Role-Based Permissions (RBPs). It’s an all-or-nothing switch, meaning whoever has edit access to the Executive Review (whether it be planner manager, Executive, HR, etc.) will have the exact same privileges to export and import.  This could likely influence your decision to use this functionality or not in Production.

Some helpful SAP notes on the functionality include:

2084851 – Executive Review – Import Button Unavailable – Compensation

2172177 – Executive Review is not populating data after recent import – Compensation

2255189 – Unable to import the excel file in compensation executive review offline editing. – Compensation Management

2084853 – Executive Review – Offline Edit via Executive Review Export to Excel – Compensation

2084863 – Executive Review – Offline Edit Email Notification – Compensation

Any questions or comments, please leave me a comment below.

 

Some other links that you might like:

My ASUG Town Hall presentation on Executive Review (ASUG Webinar with Jeremy Masters)

Executive Review in SuccessFactors Compensation (SAP Blog by Jisha Jithosh)

Top Tips Integrating SAP HCM Core and SuccessFactors Compensation and Variable Pay

Compensation, SAP HCM, SuccessFactors, , , , , ,

This is what happens when you fly on a brand new Delta jet. So new that they haven’t even registered Wi-Fi. At least this blog has come out of it – hope you find it useful! I have jotted down a few of my top tips (so far) when integrating and implementing SuccessFactors Compensation and/or  SuccessFactors Variable Pay.

  • Data, data, data! OK, do we need to go through this again? Regardless of the systems being integrated, we are always attacking the same gremlins, aren’t we? As Compensation professions (or those IT Professionals supporting Compensation), there’s nothing like going through a compensation process to see how painfully obvious it is that the integrity of your core HR data is vital in your talent management processes – especially compensation.  Take, for example, an employee’s FTE % (sometimes referred to as employee percentage). If incorrect, this one data element can wreak havoc on your merit, merit budget, and incentive calculations.
  • If SAP HCM core is your system of record, be sure you are using the existing SAP provided integrations. With Integration Add-Ons 1.0 and 3.0 for SAP ERP HCM and SuccessFactors HCM Suite, both the SuccessFactors compensation and variable pay modules have pre-delivered content. You will need to time this integration with your current Foundation UDF “User Data File” file that you are using.
  • Be kind to your PI (Process Integration) middleware resources. Take them out to lunch and buy them a pizza since you will need their help. The integrations provided by SAP are SAP PI based and will need to be activated in your middleware environment. This is often a project plan task forgotten in the plan and will end up biting you if you don’t plan for it.
  • If you are migrating from ECM (Enterprise Compensation Management), don’t try to do too much with this. The new integration uses staging tables and is entirely decoupled from ECM. You may end of leveraging IT0759 or IT0761 so LTI handling, if you still intend to interface to your stock plan provider.  Also, you may need to do some incentive number-crunching for segments (e.g. “legs”, “assignments”, “rows”, etc.) in a custom infotype. You should consider keeping your existing bonus engine if your incentive plans have not been able to simplify / conform to the SuccessFactors variable pay model.
  • Don’t forgot that all of your compensation and variable pay templates need to have the <comp-group id=”xxxx”/> tag in the XML if you are sending your data from SAP HCM, where xxxx is a string with no capitalization. As the time of this writing, this can only added via the XML configuration. This tag is important since it tells the SuccessFactors system which forms (that use that template) to update during a refresh from SAP HCM. Like any tags of an XML template for compensation in SuccessFactors, the placement of this tag is very particular near the end of the XML. Read the SuccessFactors documentation carefully and be careful when you are downloading/uploading or editing the template in Provisioning.
  • Remember the power of the pay matrix (e.g. salary ranges) which drives everything from the compa-ratio and range penetration, as well as guidelines (if included as a dimension). Don’t try to interface this over ( not worth it) –  this would just be an upload every year.  If a range range/midpoint changes, the onus would be on your SuccessFactors compensation administrator to manually update that. This shouldn’t happen once the process has started unless there was an error or your compensation manager is trying to make your life more interesting…
  • Think carefully how you will leverage the Executive Review. Unlike the name implies, this functionality isn’t necessarily just for executives, but rather for calibration purposes in general. Based on Role-Based permissioning, you can define a group with display access and a group with edit access. I will be talking about this topic during the ASUG Compensation SIG (login required) later this month. If you are a SuccessFactors customer, please plan on joining me for this learning event!

That’s it for now.  Please send along any questions and comments in the area below.

Oh, and Worklogix is a Silver Sponsor at the upcoming SAP SuccessFactors conference, SuccessConnect.  If you are in Vegas, please visit us in booth #35.

Sending you my best,

Jeremy  @jeremymasters