2354890 - Incorrect / missing data for some EC fields in reports

• Report is not showing the value of a field from Employee Central.
• Report is showing incorrect value of a field from Employee Central.
• No data in report for a field although data is available in Employee Central.
• Years of service or age related fields are fetching correct data in Reports

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 HXM Suite
• Advanced Reporting
• Table Reporting

1. Create a report in Advanced Reporting or from any EC domain available in Table Report framework.
2. Incorrect or No data in one of the field although data is available in EC.

There can be multiple reason of this and one of them could be the Event Type of the rule calculating the value of that field.

1. Go to Admin Center -> Manage Business Configuration
2. Select the Portlet where the field is present.
3. Scroll down to the page end and go to Trigger Rules section.
4. See the Event Type of the rule selected to display the data of the field on the portlet.
5. If the Event Type is selected as "On View", then the calculated value do not get store on Database as it is calculated on the fly and displayed on the portlet. 
6. Calculated value will not be shown in report as it is not saved in Database.

In order to resolve the issue and reflect the calculated value in Report you need to change the Event Type from "On View" to something else.

2707073 - ORD / Report Canvas - Calculate Age / Service Period in Days / Months / Years

No, data, in, Report, Reports, Employee, Central, Ad, hoc, Reports, Table, Canvas, OnView, OnSave, Business, Rule, Transient, Field, Anniversary, age, years , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem