Symptom
- Calculated/transient fields from BizX are not available for reporting (Table, Detailed Reporting, Advanced Reporting, Stories)
- Calculated/transient are available to be selected in the report, but there is no data within it
- Data reported for a few fields is inconsistent
- Including and not limited to Time in Job, Range Penetration, Fixed Pay, Variable Pay, etc
Environment
SAP SuccessFactors HXM Suite
Cause
Calculated (transient) fields are not stored to the database as they are calculated on the fly and displayed in the user interface.
Therefore, these fields are not supported and not available for reporting.
Resolution
- As a workaround, create a calculated column in Stories / Canvas reports.
See KBA 2686340 as an example of Annualized Salary and KBA 2339132 on Compa Ratio and Range Penetration for your reference.
- This is not applicable to on Table reporting as it is not possible to create calculated columns.
- Creating calculated columns is out of the support team scope, our work is focused on bugs and malfunctions, so if you need help to create it, please contact your partner or professional services:
See Also
2324356 - Annualized Salary in Ad Hoc / Detailed reporting is blank or incorrect
2339132 - Is it possible to create ad hoc report of "Compa Ratio and Range Penetration"
Keywords
Time, in, Job, Calculated, transient, Transient, Fields,Compa, Ratio, Report, Online, Designer, Canvas, Table, Compa Ratio, Range Penetration , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-EC , Employee Central , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem