SAP Knowledge Base Article - Public

2827548 - When a picklist field is selected as a filter in Adhoc/ORD, it displays fewer values in comparison to the actual values configured in the Picklist

Symptom

When a picklist field is selected as a filter in Adhoc/ORD, it displays fewer values in comparison to the actual values configured in the Picklist

Environment

SAP Success Factors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Create a report using Adhoc or ORD (Detailed Reporting)
  2. Configure the filter section and select a field that is considered as a picklist
  3. Select "By My Selection" section (Adhoc) / "Report Values" section (ORD)
  4. Only few options are available to be selected in comparison to number of values configured in the picklist

Resolution

Reporting tools only extracts data from the source domain or schema. It does not capture the values configured in the picklist itself.

For example, You configured 10 values in the picklist configuration but only 3 values are available as an option when this field is selected as a filter (ORD/Adhoc). Those 3 values are actually saved in the domain/schema because they were used and connected to an actual data/user while the other 7 values are not yet being selected nor connected to any data/user. If a picklist value is not yet being selected to attached to any data/user, that value will never be saved in the domain/schema.

Keywords

picklist, field, adhoc filter, missing values, picklist value missing , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions