SAP Knowledge Base Article - Public

2283381 - Calculated / Transient fields are inconsistent or blank in reporting

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:

2149831 - Contacting Professional Services, Partner and Account Management Team - SuccessFactors Cloud

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, 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

Product

SAP SuccessFactors HCM Suite all versions