SAP Knowledge Base Article - Public

2613013 - Employee Pay Group Sums schema unavailable in Advanced Reporting (ODS)

Symptom

• Employee Pay Group Sums schema is not available in Advanced Reporting (ODS).  

Environment

  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas  Advanced Reporting

Reproducing the Issue

1. Go to Reporting and create an Ad Hoc/Table report with the domain: Person and Employment Info (as of Date).  
2. Look for the table: "Employee Pay Group Sums" at the end.  
3. Check the same in Advanced Reporting; the schema is missing/not available.  

Cause

'Employee Pay Group Sums' is a transient field and therefore is not made available in Advanced Reporting. 

Resolution

1. This is an expected behavior.  
2. The schema was made available earlier in Ad Hoc reporting before Advanced Reporting was developed.  
3. The fields in this schema in Ad Hoc reporting fetch data based on a sync job that runs regularly in provisioning: 2177328.  
4. Building calculated columns for the desired transient fields or utilizing one of the EC standard reports is the most reliable option.  

Keywords

Employee Pay Group Sums, Realms, ODS, missing, schema, table, Advanced, report, transient, field, canvas, center, Ad, Hoc , KBA , ss_anonymizedkba , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC , Employee Central , Problem

Product

SAP SuccessFactors HCM Suite all versions