The Annualized Salary and other columns in the ‘Employee Pay Group Sums’ in the ‘Person and Employment Info (as of Date)’ ad-hoc domain does not return any value.
Reproducing the Issue
- Create an ad-hoc report using the ‘Person and Employment Info (as of Date)’ domain
- Select all the columns from 'Employee Pay Group Sums' table
- Run/preview the report.
- No data in Annualized Salary and other columns in 'Employee Pay Group Sums' table
For the Annualized salary and data in other columns of the 'Employee Pay Group Sums' table to be reportable, it requires a sync job to be set-up.
If the sync job is not set-up, the ad-hoc reports would not return any value.
Please refer to Knowledge Base article 2080171 and raise a Product Support Incident to get the HRIS PayComponentGroup Sums Sync job enabled on your instance.
Please also note, if you have not yet had ODS (Advanced Reporting) enabled for your Employee Central instances, please do consider this as an alternative option, as the same is available in Advanced Reports for EC.
The reports that deliver this are -:
ECODS$Annual Compensation Overview
ECODS$Annual Compensation History
You can download the above ODS report templates from http://community.successfactors.com/t5/Reporting-and-Analytics-Product/1505-Release-Employee-Central-Standard-Report-templates-for/ba-p/106084
And you are able to add them without Product Support assistance by following the guide found on the same page- Advanced Reporting – Implementing Standard Report Templates
If you encounter any issues with the above link or need assistance with adding these reports to your ODS installation, please feel free to raise an Incident with the Analytics Product Support team.
Knowledge Article 2080171
KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To