SAP Knowledge Base Article - Public

3147971 - Unable to report on 'Time In' field

Symptom

Is it possible to report on 'Time In' field in Advanced Reporting or story Reporting.

 

Environment

SAP SuccessFactors HXM Suite

  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    • Advanced Reporting (ODS)
  • People Analytics (Analytics Cloud for SF)
    • Query Designer - Filter, Calculated Column, Params

Cause

'Time In' field is Calculated (transient) fields which is not stored to the database as they are calculated on the fly and displayed in the user interface.
Therefore, this field is not available for reporting.

Resolution

As a workaround, customer can report to fetch information about how long an employee has been in a specific organizational unit, job, and position, SAP has designed a standard report which is available in content store.

The title of the template story is SF_EMP_Time_In_Report_v1.1.

See Also

Time In - Standard Story Report

Keywords

Time In, Story, Canvas, Advanced, field, missing, Stories, Story, People, analytics, time, Employment History, Number of days, days worked , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To

Product

SAP SuccessFactors HXM Suite 2205