Page tree
Skip to end of metadata
Go to start of metadata

The Exam Item Analysis report returns the questions that were associated   with an exam at run time. Exams can be randomized, their questions drawn from   a pool. The report accounts for randomization and pools.

 

Report NameExam Item Analysis
REPORT_NAME_IDExamItemAnalysisCustom
REPORT_ID128
CATEGORY_IDContent
GROUP_IDUserExamItemAnalysis
WORKFLOW_IDRun Exam Item Analysis Report
TYPEBIRT /PRD
USER_TYPEAdmin
SHOW_IN_MENUYes
DMN_IDPUBLIC

 

 

Exam
SELECT c.exam_name, 
       c.description, 
       Count(DISTINCT b.stud_id) AS learners 
FROM   pa_cbt_stud_exam_question a, 
       pa_cbt_stud_cpnt b, 
       pa_cbt_exam_def c 
WHERE  c.exam_name = a.exam_name 
       AND a.stud_cpnt_id = b.stud_cpnt_id 
/** and a.exam_name in [ExamNameSearch]      and [security: pa_cbt_exam_def c]    */ 
GROUP  BY c.exam_name, 
          c.description 
QuestionDetail
SELECT ROWNUM, 
       a.responses, 
       a.choicexml, 
       a.responsetype, 
       a.distractor AS question_object 
FROM   TABLE(pkg_exam.Get_question_responses(?, ?)) a 
QuestionSummary
SELECT qe.question_name, 
       qe.version, 
       qe.revision, 
       m.description, 
       cnt.question_id, 
       cnt.learners 
       AS responses, 
       cnt.exam_name, 
       qe.question_type_id, 
       pkg_exam.Get_question_stem(pkg_tool.Get_clob_from_blob(qe.question_data)) 
       AS 
       question_object 
FROM   pa_cbt_question qe, 
       pa_cbt_question_metadata m, 
       (SELECT question_id, 
               Count(*) AS learners, 
               exam_name 
        FROM   pa_cbt_stud_exam_question c 
        WHERE  c.exam_name =? 
       GROUP  BY question_id, 
                 exam_name) cnt 
WHERE  qe.question_id = cnt.question_id 
       AND qe.question_name = m.question_name 
ORDER  BY 2 

 

Link: http://wiki.scn.sap.com/wiki/x/loERG

 

 

 

  • No labels