SAP Knowledge Base Article - Public

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


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


SAP SuccessFactors HXM Suite Core 2205

Advanced Reporting


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.


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


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


SAP SuccessFactors HXM Suite Core 2205