Symptom
- Some fields are not available for filtering under Manage Filters in LMS Canvas / ORD reports.
- nothing fetches in Field in Run Time Filters under Report Values, even if the data for these fields are present in the report.
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 HCM Suite
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
- Online Report Designer
Reproducing the Issue
- Navigate to Report Center
- Create an LMS Canvas / ORD report
- Try to apply a filter on the fields which are selected for reporting
- Some fields are not available under Manage Filters
- Above fields will show up in Run time Filters
- When trying to apply run time filter on these fields, no data will be present while the data is there when running.
Resolution
The following page lists the various tables available for LMS reporting in Canvas / ORD, and the fields that are filterable.
Filterable Fields in Online Report Designer
We can also check whether the fields are filterable or not from Edit section of the report, if we click objects present under the edit section of the report for the fields which has filter icon they will be filterable.
Note for Filterable fields: Per the current design the 'Not In' operator is not available for the Report Values filter in LMS Canvas / ORD reports.
See Also
Keywords
Filterable, Fields, LMS, Canvas, ORD, Reports, Available, Manage, Filters, Run, Time, Icon, Edit, Report, Values, not, in , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-LMS-REP , Reporting Data , Problem