3350034 - Difference in the numbers reported of active users in LMS compared to what is generated by the LMS Usage Metrics report

Why is there a difference between the numbers reported of active user in LMS compared to what is generated by the LMS Usage Metrics report

SAP SuccessFactors Learning

Scenario 1:
Navigate to People > Users
Search where Licence Type User = Active and User Status = Active
Note number of users returned

Scenario 2:
Navigate to People > Users
Search where Licence Type User = Both and User Status = Active
Note number of users returned

Scenario 3:
Run LMS Usage Metrics report
Note number of users returned

When an admin does a search for all users in LMS (scenario 1 and 2 above) these numbers are taken from PA_STUDENT table. Essentially it just returns all users based on the search criteria selected.

The LMS Usage Metrics report references a completely different table named PS_LICENSE_USAGE_METRICS. Values are inserted into this table are based on one of the three following conditions:

• User has a learning history record for an internal or external course OR
• User has enrolled in a course and that course is on the user’s learning plan OR
• User has launched a course AND that course is on the user’s learning plan.

So unless all users met one or more of these conditions, they will not be recorded in the PS_LICENSE_USAGE_METRICS and therefore will not be included in the LMS Usage Metrics report.

Thus there will be a difference between the number of records the admin search returns and what is generated in the LMS Usage Metrics report.

active users, LMS Usage Metrics report, PA_STUDENT, PS_LICENSE_USAGE_METRICS , KBA , LOD-SF-LMS-USR , User Entity , LOD-SF-LMS-REP , Reporting Data , How To