SAP Knowledge Base Article - Public

3554016 - How to use all "application status" values as a filter in Story Report - Recruiting Management

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

  1. In Report Center, create a Story report
  2. Select Job Requisition table as a start one
  3. Select Job Application table
  4. Set filter with "application status" field from job application
  5. 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

Product

SAP SuccessFactors Recruiting all versions