SAP Knowledge Base Article - Public

2364155 - Age field not displaying correct values in Reporting

Symptom

  • A field containing employee age appears in Reporting (e.g. in the Personal Information object) but the values do not always appear, or none do.
  • This applies to Ad Hoc (Report - Table), Detailed Reporting and Advanced Reporting (Report - Canvas)

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Core - Advanced Reporting

Cause

Age is a transient value, calculated each day from birthdate rather than stored.  Transient values are not stored in the ODS for reporting.  If some of the values are appearing, this is actually caused by incorrect configuration within Employee Central making the values "persistent" and possibly out of date.

Resolution

Create a calculated column named Age.

Drag the birthdate field onto the canvas and left-click it.  From the Function list, select Age.

This calculated column will dynamically calculate age from birthdate whenever the report is run.  This is more reliable than any value stored in the ODS.

See Also


Calculated fields are not available in reporting:  See Here

- ORD / Report Canvas - Calculate Age / Service Period in Days / Months / Years see: Here

Keywords

Age Field, Incorrect data, Adhoc report, Advanced Reporting ' Online Report Designer, transient , ODS, Report Canvas, Age , length of service , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC-ROD , Advanced Reporting (Employee Central ODS/ORD) , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

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