SAP Knowledge Base Article - Public

2506640 - How to get Position ID in a query/report based on Employment in Advanced Reporting

Symptom

  • How to create a query or report with Position ID
  • Currently when using the Position field under Global Job Information, the number that appears does not match the actual Position ID
  • The Position field represents the internal ID

Environment

  • SAP SuccessFactors HXM Suite
  • Report Canvas on Advanced Reporting query

Reproducing the Issue

  1. Go to report center and select canvas reports
  2. Create an Advanced Reporting query
  3. What do you want to report on? Employment > Expand Global Job Information > Select Position field

Resolution

To report on actual Position ID:

  • Instead of selecting Position field from Global Job Information, select right arrow next to Global Job Information and find Position table
  • Expand to see Position Position
  • Expand further to see all fields and find Position Position ID field and add to query

KB - position table position ID.png

See Also

WST-6347

Keywords

Position code; Advanced reporting; ORD; Realms , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors Workforce Analytics all versions