SAP Knowledge Base Article - Public

2861553 - Filterable fields in LMS Canvas / ORD reports

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

  1. Navigate to Report Center
  2. Create an LMS Canvas / ORD report 
  3. Try to apply a filter on the fields which are selected for reporting
  4. Some fields are not available under Manage Filters
  5. Above fields will show up in Run time Filters
  6. 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

filterable2.jpg

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

2499262 - Summary of tables and fields from LMS available in Online Report Designer

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

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Learning all versions