Symptom
"Workflow Request Analysis" standard Story report only shows CHANGE_GENERIC_OBJECT request type.
Is it possible to fetch other request types in the report?
Environment
SAP SuccessFactors HXM Core
SAP SuccessFactors People Analytics
Reproducing the Issue
- Go to Report Center
- Run the Workforce Request Analysis standard Story report
- Notice that in Processed Workflow Request Details table widget, only CHANGE_GENERIC_OBJECT workflow request type is shown.
Resolution
By default, the Workflow Request Analysis standard Story report only shows CHANGE_GENERIC_OBJECT request type due to the INNER JOIN relationship between Employee Workflow Request and Generic Object Workflow Request tables.
To show other request types in the report, we need to change the relationship between Employee Workflow Request and Generic Object Workflow Request tables to LEFT OUTER JOIN.
See Also
Keywords
workflow request, request type, story report, standard story report, workflow, workflow request analysis, story template, workflow template , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , Problem
Product
Attachments
Pasted image.png |