Symptom
A field, which is visible in a template, is not available to select when making an ad hoc report in the same domain.
Environment
- SAP SuccessFactors Workforce Analytics
- SAP SuccessFactors Career Development Planning
- SAP SuccessFactors Performance & Goals
Reproducing the Issue
- Go to Home - Analytics - Reporting - Ad Hoc Reports.
- Create a new single domain report and select the appropriate domain.
- In Data Sets, select the appropriate template.
- In Columns, look for the expected field in All Columns. (A browser text search will work.)
Cause
If there's a field with the same ID and same reportable number in different templates for the same domain (e.g. two fields with ID "results" and reportable ID "field1" in two Development Plan templates), the field may not display in the column selection in Ad Hoc Reports.
Resolution
Ensure that this is not happening by changing the field's ID or reportable number in the selected template, or else deactivate other templates that use it, and re-sync.
See Also
For more information on the configuration on making fields reportable, refer to the Development Goals and Learning Activities - Ad Hoc Reports Wiki Page.
Keywords
CDP Goals, Objective Management field not display column select, field, missing, label, mismatch, template, new , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-CDP , Career Development Planning , LOD-SF-GM , Goal Management , Problem