SAP Knowledge Base Article - Public

2495688 - Report Values are missing in filter of ORD report created on LMS domain

Symptom

  • Unable to go past 20 pages of report values, while trying filter on a column from the Learning domain field.
  • Unable to find all values of a field while trying to apply filter on that field in ORD report of LMS domain.
  • Limitation of 200 values for runtime filters for LMS ORD Reports.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  • Reporting > Canvas Detailed Report > Learning > Select few fields from any tables available under Learning
  • Assume Field 'A' has more than 500 values
  • Apply filter on Field 'A'
  • Unable to find all values in filter
  • Editing the query in Detailed Reporting or using the field as a run time filter and previewing it from Report Designer give the same result

Cause

Expected behavior. Known system limitation.

Resolution

  • There is a limitation of 200 values for runtime filters for LMS ORD Reports.
  • If the customer has more than that amount of records being returned in the list they can simply directly enter the values they need to create the report, rather than selecting them from a list.
  • As alternative please use 'Enter Filter Values' option (text box). 

Keywords

  • ORD
  • LMS
  • Report Filter
  • 200 
  • Limitation
  • Missing values in filter
  • Runtime Filter
  • ORD LMS Report
  • Learning filter limitation
  • Canvas
  • Online Report Designer
  • Report center
, KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions