Cube_Room_Usage Cube_Room_Usage


Cube_Room_Usage holds information about room usage across the UEA, for rooms where the events are recorded 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 Room Event Details of the event in the room.
Date Room Date The date of the event.
Time Room Time The time the event starts.
Room  Room  Details of the room. 


Cube-Specific Dimensions

Room Other 

Field Description Derivation
Wednesday Afternoon 

Whether Wednesday afternoons should be included in the analysis.

Wednesday afternoons are set aside for games, so there are no

lectures normally booked then.  

If date is Wednesday and hours >= 13 then 'YES'

else not populated.



The measures used are based upon fields retrieved from the underlying Fact table Fact_Room_Usage.  These include

Cube Measures Group Cube Field Derivation Description
  Used Room Hours Number of hours the room was used  
  Available Room Hours Number of hours the room was available  
  Room_Hours_Usage_Percent Percentage of hours the room was used, when it was available.  
  Room Count Distinct number of rooms.  


Technical Notes

 The underlying view used for the measures is Fact_Room_Usage.