SAP Knowledge Base Article - Public

2685404 - Level field is blank - Adhoc Report

Symptom

The field "Level" from Employee Information table is blank in Adhoc for Employee Profile and Succession domains

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

Reproducing the Issue

  1. Go to Adhoc and create a report from Employee Profile or Succession
  2. Select the field "Level" from employee information table
  3. Check in the result that this field will be blank for all users
    sc.pngep.png

Cause

The Level field comes from the table sm_user_info, which has blank value populated in this field.
In Adhoc Employee Profile and Succession, the Employee information's Level, Incumbent's Level and Nominee's Level are sourced from the same table sm_user_info.

Resolution

This is expected behavior and Engineering is evaluating the possibility to improve this in future release.

Note: You can have Level information showing in the Employee information portlet, but not showing in the report.
That happens because the Level field from the portlet is stored in an user_customfield. The custom field can display data correctly in Adhoc using Employee Profile domain.
However, the custom field is not going to populate data in Succession domain.

Keywords

field Level Employee Information blank empty not populate Adhoc Profile Succession domain Incumbent Nominee Levels , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions