SAP Knowledge Base Article - Public

2727823 - How to report on Number of Openings in Job Requisition - Adhoc/Online Report Designer

Symptom

How to report on Number of Openings from Job Requisition in Adhoc or Online Report Designer

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Resolution

Open the Job Requisition and check the Number of Openings:
job req.png

Adhoc

  1. Go to Adhoc report and select the domain "Recruiting V2"
  2. Go to Columns and click on the Job Requisition table on the left side
  3. Select the fields "Number of Openings" and "Openings Filled"
  4. Check the result:
    adhoc.png

Note that in Adhoc you will not be able to get the remaining value e.g. 6. This is possible only via Online Report Designer.

Online Report Designer

  1. Go to ORD and create a Detailed Reporting query of Recruiting V2 domain
  2. Select the fields "Number of Openings" and "Openings Filled" from Job Requisition table
  3. Now create a calculated column and subtract the "Number of Openings" from the "Openings Filled"
    calculated column.png
  4. See the result
    result.png

Keywords

How to report on Number of Openings from Job Requisition in Adhoc Online Report Designer ORD , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-RCM , Recruiting Management , How To

Product

SAP SuccessFactors Workforce Analytics all versions