Symptom
- Is it possible to create Table report of "Compa Ratio and Range Penetration"?
- Can we create Table report of "Compa Ratio and Range Penetration report"?
- Compa Ratio Field does not fetch any data in Table Report.
Environment
- SAP SuccessFactors HXM Suite
- Canvas reports Advanced Reporting
Cause
- To create report on "Compa Ratio and Range Penetration report", huge amount of calculation needs to be done.
- Currently Table Report does not have functionality to create custom calculation.
- Currently, Compa Ratio field does not fetch data in Table Report because it's value is present in the UI for Employee Central (EC) are calculated on the fly and are not stored in the database.
Resolution
- It is not possible to create Table report of "Compa Ratio and Range Penetration report".
- Employee Central customers who has Advance Reporting configured in the instance can use standard EC Report Template - "CompaRatio&Range Penetration".
- You can find the latest EC Standard report templates in the the SAP SuccessFactors Workforce Analytics page on the Help Portal as described in the KBA 2679275 - Where to find the latest version of EC Standard Reports and corresponding documents
Navigation Steps to find the report template in Marketplace: Products > Installation & Upgrade Guides > Cloud Solutions from SAP > SuccessFactors > Analytics - Also, look into following to KBA articles for detail information regarding logic implemented behind "Compa Ratio and Range Penetration" calculation.
2271107 - How to export Pay Range Foundation Object for value check
2136061 - How to determine which Pay Range is used in the Compa-Ratio and Range Penetration calculations - Employee Central
See Also
2271107 - How to export Pay Range Foundation Object for value check
2296053 - How to Implement Employee Central Standard Reports Templates for Advanced Reporting
2559179 - Compa Ratio and Range Penetration report - Advanced Reporting
Keywords
Table report, Ad Hoc Report, Compa Ratio, Range Penetration, Compensation information, advanced reporting template , KBA , csg_q , report , compa ratio , adhoc , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To
Product
SAP SuccessFactors HCM Suite all versions