SAP Knowledge Base Article - Public

2529638 - Filter Selector is Missing Values on Learning Data - ORD/Learning

Symptom

When running a report using Live Data on Learning, the filter selector is missing values for several fields as per the screenshot below.

Screenshot KBA.png

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

  1. Create a ORD report of LMS domain
  2. Go to Manage Filters or Runtime Filters
  3. Select a Filter field
  4. Click on Report Values
  5. Try to search for a specific value
  6. 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

Product

SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors Learning all versions ; SAP SuccessFactors Workforce Analytics all versions