SAP Knowledge Base Article - Public

2608673 - Picklist labels are not available in object filter in advanced reporting queries / reports

Symptom

Picklist labels are not available in object filter in advanced reporting queries / reports

Environment

SuccessFactors

Online Report Designer

Reproducing the Issue

  1. Open the report in Edit mode in report designer.
    or
    Open a query in Advanced Reporting directly.
  2. Select any object and go to Filter section of that object
    (Edit Restrictions)
  3. The picklist field will only show the numeric codes(raw data) and not labels.

Cause

This is expected behavior as this filter has only raw data available for comparison and it does not offer calculated column or other tables.

Resolution

  1. Use only the internal code and Label fields in a separate query.
  2. Export the results.
  3. Use this as a reference to filter on the relevant values.

Keywords

Picklist Label Filter Object Filter Report Filter

Edit Restrictions

Advanced Reporting

Internal Code , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Core all versions