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)
SuccessFactors 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.
2283381 - Calculated fields are not available in reporting
Online Report Designer
Report Canvas , KBA , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-EC-REP , Reporting Data , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem