Dimensions

Dim.Date (Date Dimension)

SUMMARY The Date Dimension allows users to view fact data (e.g. Sales) by Date and date intervals e.g. Week, Period, Quarter, Year. The presentation table contains a row for every date from 1995 to 2025, and each one of these dates has the relevant attributes to allow the grouping of fact data by these attributes.

Dim.Time (Time Dimension)

SUMMARY The Time Dimension allows users to view fact data (e.g. Sales) by Time and time intervals e.g. Quarter Hour, Half Hour, Hour or Trading Session. The presentation table contains a row for every minute from 04:00 to 03:59 (ordered in this way to match the conceptual trading day), and each one of these times has the relevant attributes to allow the grouping of fact data by these attributes.

The table allows trend analysis by Time

Dim.Pub (Pub Dimension)

SUMMARY The Pub Dimension contains all Pubs in the estate, including those acquisitions that have been assigned a Pub Number but are not yet trading, and those that subsequently close. The presentation table contains a row for every Pub (from the Excel Pubs by AM List), and all the associated details of each pub that are required for reporting.

The relationship between the Pub Dimension and Cost Centre Dimension is one Pub to many Cost Centres. A Pub which has a Hotel will have two Cost Centres for the Pub and Hotel, linked to one Pub in the Pub Dimension, which represents the overarching Pub entity.