SAP Knowledge Base Article - Public

2158287 - How do I report on ‘Time In Position’ filed in ODS/Advanced Reporting?

Symptom

How do I report on ‘Time In Position’ field in ODS/Advanced Reporting? The field is available in EC under the ‘Job Information’ portlet. However, I am unable to locate the field in ‘Job Information’ table in ODS.

Environment

  • Successfactors HCM Core
  • Advanced Reporting in EC (ODS/REALMS)
  • Detailed Reporting

Reproducing the Issue

  1. Login the instance 
  2. Reporting / Analytics 
  3. Report Center > Canvas Report > ( or Analytics > Advanced Reporting)
  4. Employment > Global Job Information > Time in Position not available. ( same for Time in Job, Time in Location, Time in Company )

Cause

Time In Position is a transient field, the value of the field is a calculated on the fly and is not stored in the database. (same for Time in Job, Time in Location, Time in Company)

The value displayed here is a difference in Years, Months and Days (2 Years, 3 Months and 5 Days for example) between the Current date and the ’Position Entry Date’.

As the value of the field changes every day, the value is not stored in the database and is calculated on the fly when the ‘Job Information’ portlet is accessed.

As the value is not stored, it is not possible to report on this field.

The TimeIn Calculation calculates the number of years/months/days an employee has worked on a job, position, company, location, department or pay scale level. This value is transient.

Resolution

It is not possible to report on this field in the exact format as it appears in (2 Years, 3 Months and 5 Days) the instance.

However, the values 2.26 Years or 27.16 Months or 827 Days (approximately) can be derived using the calculated columns feature in Advanced Reporting.

See Also

This also holds true for other fields where the values are displayed in Years, Months and Days format calculated as difference between current date and another field.

Keywords

KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors Workforce Analytics 1705