Symptom
- Reporting in the Canvas (Online Report Designer) 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 - Detailed Reporting Live Data, the report returns fewer results than LMS
Environment
- SAP SuccessFactors HXM Suite
- SAP SuccessFactors Learning
- Report Centre
- Online Report Designer
Reproducing the Issue
- Run a report in Canvas (Online Report Designer) that returns data from the Learning domain (ex: Curriculum Item Status)
- Note that not all of the expected data is returned
- 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 (Online Report Designer)
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 (Online Report Designer) Best Practices for reporting size prior to increasing the amount of data to be returned
- Logon to LMS Admin
- Navigate to System Admin > Configuration > System Configuration
- Open the REPORT_SYSTEM configuration file in Edit mode
- 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"
- Review the Period settings for Learning Entities (ex: the Curriculum Period is based on the Curriculum Assignment Date to Users)
- 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
- 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
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 HXM Suite all versions ; SAP SuccessFactors Learning all versions