Symptom
In Story report, when creating report for job application table, you can only select few status values from "application status" as a filter.
How to use all "application status" values as a filter?
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
- In Report Center, create a Story report
- Select Job Requisition table as a start one
- Select Job Application table
- Set filter with "application status" field from job application
- See only few values show up
Cause
Story reports are designed in a way that there is a left outer join within the tables.
If you start from the job req table and you link the application, the results will start from the job req table first, showing potentially less results.
This is explained in this KBA.
Resolution
As a workaround, please create a dummy job requisition and add some candidates into this job req.
Then move these candidates to each application statuses one by one.
After that, you will see "application status" field shows all values in story report as a filter.
See Also
3529994 - Story Reports Outer and Inner Join sequence in embedded SAP Analytics Cloud (eSAC) SuccessFactors (SFSF)
Keywords
Recruitment Module, Story report, Filter application, Application Status , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , How To