Symptom
While creating an Table report you try to filter the result for a Picklist field and notice you cannot find the value from the filter search result.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SuccessFactors HXM Suite
Reproducing the Issue
- Home > Reporting > Table Report > Create an Table report (e.g. RBP Permission to User domain)
- Go To Filter Tab > Select a Field which is Picklist (e.g. Permission) > By My Selection > Search for a value (e.g. Address 1 Edit)
- The Search does not fetch the value Address 1 Edit
- If you preview the Permission field values the Address 1 Edit is available
Cause
The Auto-Search on Table filter (By My Selection) does not display all values for picklist and when the number of values in Picklist field is more than 200.
This is a know limitation of the Ad Hoc Reporting tool and cannot be changed/altered.
Resolution
1.) As a workaround you can use the page navigation to find the desired value. e.g. Address 1 Edit
If the desired value (Address 1 Edit) is not available even by navigating to the next pages make sure the below provisioning option is selected.
Note: Such option should be configured only by Implementation Partner & Professional services after understanding the impact of such option on the current functionalities.
From Provisioning:
-
Company Settings
- Select Sort Picklist Columns Based On Labels
- Save
Please be aware that enabling "Sort Picklist Columns Based On Labels" can cause issues in the filters 3026737 - Filter keeps loading forever in Report Center
2.) Another workaround is using the ORD tool instead and using Detailed Reporting as the data source of the report since this is a known limitation of the Ad Hoc Reporting tool.
Note: Detailed Reporting tool and Ad Hoc reporting tool share the same data source which is Live Data.
See Also
Keywords
By My Selection search, Filter search, Report Values, Ad Hoc, Ad-Hoc, AdHoc, Report - Table, Filter, 200, Table, Table report , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem