2364155 - Age field not displaying values in Advanced Reporting

SAP Knowledge Base Article - Public

2364155 - Age field not displaying values in Advanced Reporting

Symptom

A field containing employee age appears in Advanced Reporting (e.g. in the Personal Information object) but the values do not always appear, or none do.

Environment

SuccessFactors 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

2283381 - Calculated fields are not availble in reporting

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-EC-REP , Reporting Data , Problem

Product

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