SAP Knowledge Base Article - Public

3247907 - No data returned when using picklist label field as a filter in the report

Symptom

Report does not return data when picklist label field is used as a filter.
Issue is specific to one picklist label value only.

Environment

SAP SuccessFactors HXM Suite Core 2205

Advanced Reporting

Cause

Picklist label value contains an extra space in Picklist Center. Hence, when the label is used as a filter, it does not fetch the records in the report output as these do not contain that extra space.

Resolution

Correct the data in Picklist Center by removing that extra space in picklist label or use the external code instead in the report filter.

The best practice when using picklist field as a filter, we select the external code instead of the label/description field.

See Also

2600093 - No Data Available when Running a Report in Another Language - Advanced Reporting

Keywords

KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite Core 2205