Cube_Access_Event holds details of swiped access using campus cards to specific rooms.
The information is taken from Gallagher, the access control system.
Dimensions in the cube based upon Shared Dimensions are as below. Details of these columns are held in the Shared Dimensions section.
|Shared Dimension Name||Name in Cube||Notes|
|Member and Course||Access Member||The dimension takes fields from both Dim_Member and Dim_Course. The current course details are retrieved.|
|Date||Access Date Start||
This is the date the card was swiped to gain access.
|Time||Access Hour Start||The hour when the card was swiped. Note the minutes are removed, so 9.50 will become 9.00.|
This holds a range of unrelated fields, as held on the fact table
|Source System||The source system where the records come from||Hard-coded as 'GALLAGHER'|
|Access Event Src||The source identifier for the specific event.||Event.id|
|Access Item Src||This holds the 'zone' (room/ building) the swipe was for.||FTIItem.name|
|Access Item Type Src||The type of access being granted -||Hard-coded as 'ZONE'.|
|Access Start Datetime Src||The precise date & time te swipe took place.||Event.occurrencetime|
|Cube Measures Group||Cube Field||Description||Derivation|
|Access Event||Access Event Count||Number of events.|
|Access Members||Campus Card Count||Number of distinct campus cards (equivalent to number of people)|