SAP Knowledge Base Article - Public

2341864 - Data discrepancy between ORD and LMS on learning data returned

Symptom

  • Reporting in the Online Report Designer (ORD) might result in a discrepancy between the number of results between the ORD and what you can see in LMS (Learning Management System)
  • In the Online Report Designer, the report returns fewer results than LMS

Environment

  • SAP SuccessFactors Learning Management System (LMS)
  • SAP SuccessFactors HCM Suite
    • Report Centre
    • Online Report Designer

Reproducing the Issue

  1. Run a report in ORD that returns data from the Learning domain (ex: Curriculum Item Status)
  2. Note that not all of the expected data is returned
  3. Running a similar report in LMS (ex: Curriculum Item Status (CSV)) with the same filter criteria results in all of the expected data

Cause

  • While designing the report, the results are by default limited to the last 3 months (preview)
  • When running the full report, it limits to a 3 year (36 month) period
  • This includes exports, LMS entity periods which are older than 3 years will have a discrepancy in the data available between LMS and ORD

Resolution

The Preview and Full Report periods can be increased in the REPORT_SYSTEM configuration files in LMS Admin

Note: Please review KBA 2418819 for ORD Best Practices for reporting size prior to increasing the amount of data to be returned

  1. Logon to LMS Admin
  2. Navigate to System Admin > Configuration > System Configuration
  3. Open the REPORT_SYSTEM configuration file in Edit mode
  4. Search for the entry starting with "# The default period for mandatory filter prompts for which the ORD (adhoc) reports shall be generated with. Attribute in unit months"
  5. Review the Period settings for Learning Entities (ex: the Curriculum Period is based on the Curriculum Assignment Date to Users)
  6. Note the defaults:
    • # Default value set to 36 Months/3 Years
    • # Default value set to 3 Months for the report in the Preview/Design Mode
  7. To update the period for Preview and Full return options for an ORD report based on Learning data, modify these two properties (units are in months):
    • adhocReportDefaultPeriod=36
    • adhocReportPreviewModeDefaultPeriod=3

Keywords

LMS, ORD, Learning, Data, entity, domain, curriculum, curricula, item, user, assignment, missing, different, discrepancy, few, less, blank, empty, report, Online, designer, centre, canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-ORD , Online Report Designer , Problem

Product

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