Symptom
Not able to report on certain fields in Canvas - Advanced reporting as the fields are not available.
Environment
- SAP SuccessFactors HXM Suite
- Report Canvas
- Advanced reporting
Reproducing the Issue
- Create a report in Canvas - Advanced reporting.
- Search for the a particular field in query designer.
- Certain fields are missing - not available for reporting.
Cause
- The field config should be present in the 'Manage Business Configuration' for HRIS fields, and 'configure object definitions' for custom MDF objects.
- For a field to appear in advanced reporting, at least one employee should have data in the system for that field.
Resolution
It is an expected behavior.
To make the column available in the Advanced report, please do the following.
- Field configuration should be present in the 'Manage Business Configuration' for HRIS fields, and in 'configure object definitions' for custom MDF objects.
- Please make sure that at least one employee should have data in the system for that field.
If the field is present in the config and data is also maintained for that field for, but still field is not showing in Advanced reporting, then a metadata cache purge needs to be done which will allow the config change to appear in advanced reporting.
See Also
Keywords
Advanced, reporting, column, missing, field, ORD, canvas, metadata, cache, purge , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem
Product
SAP SuccessFactors HCM Suite all versions