SAP Knowledge Base Article - Public

2177328 - No Data in ‘Employee Pay Group Sums’ column set in ‘Person and Employment Info (as of Date)’ ad-hoc report

Symptom

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

  1. Create an ad-hoc report using the ‘Person and Employment Info (as of Date)’ domain
  2. Select all the columns from 'Employee Pay Group Sums' table
  3. Run/preview the report.
  4. No data in Annualized Salary and other columns in 'Employee Pay Group Sums' table

Cause

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.

Resolution

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.

See Also

Knowledge Article 2080171

Keywords

KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Suite all versions