SAP Knowledge Base Article - Public

2769708 - Deleted Picklist Values are Listed as Options in Filter Designer - ORD/Advanced Reporting/Canvas

Symptom

We are seeing unused or deleted picklist values when defining filter criteria in Online Report Designer / Advanced Reporting / Report - Canvas.

Environment

SAP SuccessFactors Reporting and Analytics
Advanced Reporting

Reproducing the Issue

For example:

  1. Create a new Advanced Reporting query from Global Job Information.
  2. Click on the Filter icon and look for the field Event (Label)
  3. Notice that options include inactive or deleted picklist values.  You can compare this by going to Admin Center > Picklist Management > Export picklist and look for the available 'events'

Resolution

It is expected behaviour the Filter Designer screen shows active and deleted picklist values. There is no hard-wired filtering applied on the picklist status.

So it is working as designed that you can see the unused picklist valyes in the Filter dialog screen when defining static filters.

Deleted picklist values though won't be listed as options when the picklist field is used as Runtime filter because there is no data or record holding that value.

Keywords

filter designer available values, picklist fields in report filter designer, advanced reporting picklists, deleted picklist filter, inactive picklists, report filters, WFA-19948 , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Suite all versions