SAP Knowledge Base Article - Public

2838861 - How to report on employees who do not have a Profile Picture

Symptom

Fetch a report of employees who do not have a profile picture.

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

Environment

SAP SuccessFactors HXM Suite

Resolution

  1. Create a new Report-Canvas
  2. Add a List Report Component to the page
  3. Select the component > Edit Query > Advanced Reporting > New
  4. Choose Employment Realm > drag and drop 'Global Job Infomration' to Objects
  5. Expand 'Global Job Information' and look for 'Employment Photo' > drag and drop the same to Objects
    Objects.PNG
  6. Add an Object Level filter on 'Employment Photo' object. 
    ObjFilter1.PNG
  7. Filter condition to be "Phototype in 20" and "Null". Depending on the instance configuration the profile picture phototype can be 1, in this case please filter by "Phototype in 1, Null".

    Capture.PNG

  1. Fetch Results
  2. All the employees who have 'User Sys ID' column of 'Employment Photo' object blank DOES NOT have a profile picture
    Data.PNG

Keywords

employment, photo, profile, picture, employee, user, person, no, report, canvas, advanced, reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite all versions