2364155 - Age field not displaying correct values in Reporting

• 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.

SAP SuccessFactors HCM Core - Advanced Reporting

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.

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.

Calculated fields are not available in reporting:  See Here

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

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-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC-ROD , Advanced Reporting (Employee Central ODS/ORD) , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

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