Cube_Room_Usage holds information about room usage across the UEA, for rooms where the events are recorded on SITS.
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.|
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.|
The underlying view used for the measures is Fact_Room_Usage.