SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Learning
  • Report Centre

Reproducing the Issue

  1. Run a report in  Canvas 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 Canvas 

Resolution

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

Note: Review KBA 2418819 for Canvas 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

Keywords

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

Product

SAP SuccessFactors HCM suite all versions ; SAP SuccessFactors Learning all versions