Cube_Access_Event Cube_Access_Event

Introduction

Cube_Access_Event holds details of swiped access using campus cards to specific rooms. 

The information is taken from Gallagher, the access control system.

Shared Dimensions

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.

 

Cube-Specific Dimensions 

Access Other

This holds a range of unrelated fields, as held on the fact table

Field Description Derivation
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

Measures

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)