3625766 - Progress Measure field is empty in Story reports

Upon adding Progress Measure field from User Online Content table in the query designer of a Story report, the field is always empty in the output despite the SCORM 2004 content communicating such value to LMS.

SAP SuccessFactors Learning

1. Create a Story report to report on the progress measure of users communicated by the SCORM 2004 contents
2. Add User Online Content table to the report query
3. Select Progress Measure field from above table
4. Preview query or run the report and notice that the Progress Measure field does not have any data, despite your SCORM 2004 content communicating a value for it in the content debug logs

The value you are looking for comes from the cmi.progress_measure parameter and it is a progress indicator sent by the content with a value between 0.0 and 1.0.

This value is stored by LMS in the PA_CBT_STUD_CPNT_MOD table.

While you can enable the Progress Measure field from the "User Online Content" table in a story report query builder, the actual table name connecting to PA_CBT_STUD_CPNT_MOD DB table is the one called "User Online Content Module".

This is how you should do it:

• Table joins required: User > User Online Content > User Online Content Module
• Enabling field: User Online Content Module table is the one actually storing the data you need, this is the table where you take the Progress Measure field from and not from the User Online Content table

NOTE:

• Product Support's scope on Story reports is only the validity of the LMS data retrieved via the Live SAC-LMS connection, confirming if the retrieved data is matching the data stored on your LMS Data Base schema. Questions regarding creating custom Story reports, table joins, how to create a query for a specific business need etc. are considered as consulting queries and should be raised on the channels mentioned in 3625027 - Support Scope for Consulting questions and Creation of Story Reports, Tiles and Dashboards - SuccessFactors Learning
  
  
• In case the Progress Measure is empty and not returning any data even from the User Online Content Module table, that means we did not receive such value from your SCORM content when the user interacted with it the last time.
• In case the returned value seems to be incorrect from your perspective, please keep it in mind that we can store only those values we received from the content.

Any of these problems are needed to be reviewed by your content developer as SAP SuccessFactors LMS is providing only the platform to play your contents but we are not in charge of your actual SCORM content packages. We can store the data we receive from the content, however our product is not able to overwrite or set those values on it's own and requires the SCORM content to communicate everything correctly. 

Structured Content Troubleshooting

3625027 - Support Scope for Consulting questions and Creation of Story Reports, Tiles and Dashboards - SuccessFactors Learning

Structured Content Troubleshooting

SCORM 2004 API Calls Supported by SAP SuccessFactors Learning

progress measure, content, user online content, user online content module, PA_CBT_STUD_CPNT_MOD, story, report, query, SAC, SCORM, SCORM 2004 , KBA , LOD-SF-LMS-SAC , Stories for Learning , How To