SAP Knowledge Base Article - Public

2230818 - Performance management Adhoc Report-Ratings are not reportable once inactive users forms are deleted.

Symptom

Completed Date and Ratings are not pulling up on the adhoc report for the deleted forms of inactive users.

This article explains how you can extract data like ratings, completed date etc for the deleted forms of active/inactive users.

Environment

  • Performance Management
  • Adhoc Reporting

Reproducing the Issue

Steps to reproduce:
1. Create Forms for a subject.
2. Route the Form to the completed stage or just keep it in In- Progress with Ratings filled.
3. Change the Subject to Inactive.
4. Generate Ad Hoc report of the Form ---> Observe that the Form Content like the Ratings Information are displayed in the Report.
5. Delete the Form through Admin Tools -> Delete Documents.
6. Generate Ad Hoc report for the Form again ---> Observe that the Form Content like the Ratings Information have disappeared from the Report.

Cause

When you delete a document, the content from the FEEDBACK table is deleted.
The rating information comes from FEEDBACK table, hence you would not see the data in the adhoc report.

Resolution

We can use the Detailed Document search to generate the report for the deleted form of active and inactive users.There is no seperate option to generate the report only for inative users in detailed document search.

The Data in Detailed Documnet Serach report comes from form data table & we have a flag in the table to identify whether the form is deleted or not.The form data is  still saved in the table if the form is deleted, so the deleted form's rating are reportable in Detailed Document Search report.

If we need only the ratings data for deleted foms for inactive users,we should first generate an adhoc report for deleted forms in which ratings data is missing.Later we would generate another report using Detailed documnet search which has all the information like ratings,completion date etc for deleted forms of active and inactive users.

Then we can use option like vlookup to get the ratings for the deleted forms in the adhoc report

Keywords

  • Performance Management
  • Adhoc report
  , KBA , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , How To

Product

SAP SuccessFactors HCM Suite all versions