2084830 - Reports - Data not showing in an EC Ad Hoc report - Compensation

• Creating an Employee Central Ad Hoc report with compensation fields such as Annualized Salary 
• How to Display Annualized Salary in an Ad-Hoc Report
• How to create an Employee Central Ad Hoc report that contains both EC employee fields and Compensation employee fields, but some compensation fields are blank on the report

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

 

• SAP SuccessFactors HCM Cloud
• SAP SuccessFactors HXM Suite
• SAP SuccessFactors Employee Central - Ad-Hoc Reporting

Data needs to be synced between EC and Compensation.

Since the data displayed in the Compensation Information is transient (calculated when the page loads), the displayed value is not stored in the database, and therefore not directly available in ad hoc reports. To display this information in the Person and Employment (as of Date) report, you must have the HRIS PayComponentGroup Sums job scheduled in your instance.

When the job runs for the first time, it will likely take some time to complete. However, once completed, all subsequent jobs that run (advised as once daily) will be much faster. Once the job is completed, the Person and Employment (as of Date) report displays the calculated values when the selected column set is Employee Pay Group Sums and a pay component group, such as AnnualizedSalary.

• The report has to use the Domain "Person and Employment Info (as of Date)" (it is not suggested to create this as a cross domain report)
• The Foundation Object fields are located in the corporate data model. 
• To pull a compensation field such as Annualized Salary, you need to synchronize these fields from the Foundation Objects with the employee fields which are in the succession data model.  To do this, The fields must be synchronized. 

• This needs to be a daily job
• When the job runs for the 1st time, it will likely take some time to complete, but once completed, all subsequent jobs that run will be much faster.

Important: 

• For any job creation please refer to: Guide: Managing Scheduled Jobs - chapter_ Chapter: Notes on Some Common Job Types
• 2512570 - Creating an HRIS Sync Job in SAP SuccessFactors Via Scheduled Job Manager or Provisioning

For HRIS PayComponentGroup Sums Sync Job Type:

The maximum times that the job can run each day in the Admin Center:

• 1 time a day.

• 1 time for a recurring job

Other Option: 

Please inquire with your Implementation Partner or Product Support, to schedule a behind the scenes operations job, known as the "HRIS PayComponentGroup Sums Sync"

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide:  Managing Scheduled Jobs

       Chapter: Notes on Some Common Job Types

    Guide: Implementing Employee Central Core 

       Chapter: Permissions for Ad-Hoc Reports and Ad Hoc Report Types

     Chapter:  Ad Hoc Report Types - Person and Employment (as of Date)

• 2080171 - Employee Pay Group Sums do not retrieve any data when selected in Ad Hoc Reports
• 2345923 - HRIS Pay Component Group Sums Sync Job Fails Repeatedly
• 3546611 - Inactive and Terminated employees are not reportable in Person and Employment (as of Date) Reports for annualized salary or pay component group sum
• 2512570 - Creating an HRIS Sync Job in SAP SuccessFactors Via Scheduled Job Manager or Provisioning
• 2177328 - No Data in ‘Employee Pay Group Sums’ column set in ‘Person and Employment Info (as of Date)’ Report Table
• 2084830 - Reports - Data not showing in an EC Ad Hoc report - Compensation
• 2317923 Employee Central - Ad-Hoc Reports 
• 2080162 - Employee Central: Ad Hoc Report Types Explained

HRIS, PayCompGroup, Transient Field, Corp SDM, SF EC, SFEC, Success factors, annual salary, AS Field, HRIS PayComponentGroup Sums  sf compensation reports, AnnualizedSalary , KBA , LOD-SF-CMP , Compensation Management , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-CMP-REC , Recurring Payments , LOD-SF-EC-CMP-NRE , Spot Bonus & Non-Recurring Payments , Problem

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core all versions