BI report on completed course information (SCORM quizz) to see questions and answers for each user

Summary

Completing the course = answering 10 random questions out of a question bank of 500 questions. Report should contain for each user: description of each question + learner response + correct response

Content

We created a SCORM course which contains a question bank of 500 questions. The learner gets 10 random multiple choice questions to complete. We have 3000 users who have to complete the course each year (course is in a periodic learning plan).

Now we would like to have an overview of the 10 questions the user got and the answers the learner gave, compared to the correct answer. If you create a custom BI report based on User-information, lmsapi_apicall and lmsapi_valuedata, you get too much information in your report.