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:
-
Create a new Advanced Reporting query from Global Job Information.
-
Click on the Filter icon and look for the field Event (Label)
-
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-ADV , Advanced Reporting (ODS) , Problem