Cube_Stage Cube_Stage

Introduction

Cube_Stage holds information about stage results for students.  It should be used where analysis of stages is required.  Stage information is also held on Cube_Assessment and Cube_Module for use in board reporting. 

Shared Dimensions

Dimensions in the cube based upon Shared Dimensions are as below.  Details of these columns are in the Shared Dimensions section.

Shared Dimension Name Name in Cube  Notes
Member Stage Member   
Fee Profile Stage Fee Profile   
Course  Stage Course The course the student was on during the stage.  Note: The current course for a student can be found on Cube_Module. 
Stage  Stage   

 

Cube-Specific Dimensions

Stage Other

This contains various columns from the underlying fact table useful for context.

Column Names Meaning
Confirmed Progression Code  
Stage Academic Year Src  Used to show academic year for the stage. 
Stage Credits  Number of credits obtained during the stage. 

Measures

The measures used are retrieved from the underlying fact table Fact_Stage_Over_Time.  These include

 Cube Measures Group Cube Field Derivation Description 
Fact Stage Fact Stage Count Number of records.   
  Stage Average Confirmed Mark Count  Number of stage_average_confirmed_marks populated   
  Avg_Stage_Confirmed_Mark   stage_average_confirmed_mark/  Stage Average Confirmed Mark Count   

 

Technical Notes