Symptom
- 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.
Environment
- SAP SuccessFactors HXM Suite
- Advanced Reporting
- Table Reporting
Reproducing the Issue
- Create a report in Advanced Reporting or from any EC domain available in Table Report framework.
- Incorrect or No data in one of the field although data is available in EC.
Cause
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.
- Go to Admin Center -> Manage Business Configuration
- Select the Portlet where the field is present.
- Scroll down to the page end and go to Trigger Rules section.
- See the Event Type of the rule selected to display the data of the field on the portlet.
- 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.
- Calculated value will not be shown in report as it is not saved in Database.
Resolution
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.
See Also
Keywords
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