Cube_Teaching Cube_Teaching


Cube_Teaching holds information about lectures, seminars and other activities recorded as events on SITS.

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
Module Teaching Module For when the event relates to a module.  Some items are not module-based.
Event Teaching Event Details of the teaching event. 
Date Teaching Date The date of the teaching event.
Time Teaching Time The time the event starts.
Lecturer Teaching Lecturer Details about the lecturer doing the teaching.
Room Teaching Room The room the lecture/ seminar is taking place in.


Cube-Specific Dimensions

Teaching Other

Column Name Derivation Description
Event Has Room 'Yes' if there is a room linked to the 'Event Instance' record, 'No' if there is no record (It is an 'unroomed event')  
Event has Staff 'Yes' if there is a staff record, as above, 'No' if not.  
Event Registration Status' Event_Registration_Summary.Event_Registration_Status - 'Full' for register taken 'No Register' if not.  A guide to which past events had registers taken.
Event Instance Src Event instance code  - evi_code  


The measures used are retrieved from the underlying Fact table Fact_Teaching_Event.  These include

 Cube Measures Group Cube Field Derivation Description 
Staff Teaching Events Number of events for the dimension values shown.  
  Teaching Duration  Total duration of the teaching events considered.   
  Avg_Student_Number_Enrolled  Average number of students enrolled on the events.   
  Room Count Number of room-based records  
Academic Week Academic Week Count Distinct count of academic weeks  
Room Room Distinct Count Distinct count of rooms.  


Technical Notes

 The underlying fact table is based upon the Fact_Staff_Teaching view.