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