Symptom
When running a report using Live Data on Learning, the filter selector is missing values for several fields as per the screenshot below.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create a ORD report of LMS domain
- Go to Manage Filters or Runtime Filters
- Select a Filter field
- Click on Report Values
- Try to search for a specific value
- See that there are no values on the box "Or, select from available value(s) below:" as per screenshot above.
Cause
The LMS team do not offer the filter value lookup for fields because this would have a performance impact on learning. Some fields have a database index over them or there is a picklist and they can be offered to the user to select. For others it would have to do a full scan the database which would be a performance hit.
Resolution
This is an expected behavior. It is possible to write the field on the search box that the filter will work succesfully.
See Also
2470892 - ORD filter for LMS is not showing all values
Keywords
Filter - Analytics - Learning - ORD - Runtime Filter , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-LMS-REP , Reporting Data , LOD-SF-ANA-ORD , Online Report Designer , Problem