Symptom
The Overall Competency and Overall Objective ratings are not displayed in the AdHoc report.
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 Performance
Reproducing the Issue
- Include the "Overall Competency Rating" and "Overall Goals Rating" columns in the AdHoc report;
- Run the AdHoc report;
- Notice that the above columns are empty in the report even if the PM form has ratings in the "Competency" and "Goals" section.
Cause
- The Objective Competency Summary section in the PM form generates the "Overall Competency Rating" and "Overall Goals Rating" in the Ad Hoc report.
- If the PM form does not include this section type, then the "Overall Competency Rating" and "Overall Goals Rating" fields will not return results in the Ad Hoc report.
Resolution
If you want to report on the Overall Objective Rating and Overall Competency Rating, you need to have an Objective Competency Summary Section in the PM form.
However, an alternative if you haven't created a form with an OCOC Summary section and with to report on the rating of your Goal and Competency section you can add the following columns in the ad hoc report:
- Section Rating
- Section Rating Label
- Section Name
You need to filter the report by the section name so that the report will only show the section rating of your Goal and Competency Section.
Keywords
Overall Competency Rating, Overall Goals Rating, Ad Hoc Report, Section Rating, Section Name, Report, Rating, Overall rating, Objective Competency Summary section , KBA , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem