SAP Knowledge Base Article - Public

2283381 - Calculated \ Transient fields are not available in reporting - Advanced Reporting

Symptom

Calculated fields from BizX are not available for reporting (Ad Hoc, Detailed Reporting, Advanced Reporting, etc.)
Including and not limited to Time in Job, Range Penetration, Fixed Pay, Variable Pay, etc.,

Environment

  • SAP-Successfactors Workforce Analytics
  • Adhoc reporting
  • Advanced reporting
  • Detailed Reporting

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 available for reporting.

Resolution

As a workaround, create a calculated column in Online Report Designer / Report-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 Ad Hoc reporting / Report-Table as it is not possible to create calculated columns.

See Also

2686340 - How to create calculated column for "Annualized Salary" field in Advance Reporting (Realms)

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 Columns
Transient Fields
Compa Ratio
Reporting
Calculated \ Transient fields
Online Report Designer
Advanced Reporting
Report Canvas , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-EC , Employee Central , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions