SAP Knowledge Base Article - Public

2149942 - Performance issues when attempting to filter on a large number of entities in LMS Reports


  • When running a learning report, generally, we use Filter to search and then select a list of entity (User, Item, etc..) as Input of the report
  • If number of the entity to satisfy one search criteria is very large (i.e., more than 10000), it will cost a lot of time to add all of them into filter
  • If some new entity is added into the system, to run the report on all of them (i.e., all users in one domain), it is necessary to change the search criteria to involve the new entities for scheduled/saved reports
  • How to run a report on multiple entities easily and dynamically?


SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  1. Login to Learning Admin application
  2. Go to Reports tab and click any report to run
  3. In Run Report window, click filter icon after one entity (i.e., User, Item, etc..)
  4. In the pop-up filter window, enter any search criteria (i.e., specific domain(s)) and then click Search button
  5. Change Records per Page to All
    =>The performance is slow to show all entities if number is very large(i.e., more than 10000)
  6. Click Select All link and then click Add to Filter button
    =>The performance is also slow to add all of them into filter
  7. Click Schedule Job or Save Report button for next time usage
    =>In this case, report will be generated without including any new entity, which is added to the system and satisfies the search criteria after that
    =>To include the new added entity, it is necessary to add it into filter as input of the report
    =>How to run the report dynamically on multiple entities without changing the filter each time?


This is expected behavior when retrieving large amounts of data


In the step 4 above:

  1. After entering search criteria, instead of clicking Search button, please click Submit Criteria button
  2. Performance will be much quicker, and all of entities which satisfy the search criteria (for example, all users in one domain) will be selected dynamically when running the report

See Also

User Assistance Documentation:


SF SuccessFactors learn, learning, lms, report, multiple, entity, user, item, selection,  large number, search criteria, submit criteria, more than slow performance many filter rep rpt , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem


SAP SuccessFactors Learning all versions