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

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

Advanced Reporting in EC (ODS)

Detailed Reporting

Cause

The value of the field ‘Time In Position’ is a calculated on the fly and is not stored in the database.

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.

The following fields are filled when job classification, position, company, location, department or pay scale level are changed. Changes are saved to the database:

Job Entry Date
Position Entry Date
Company Entry Date
Location Entry Date
Department Entry Date
Pay Scale Level Entry Date

Therefore these are the fields that can be used for reporting purposes.

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