From WISWIKI
Jump to: navigation, search

Fact.Sales (Sales Fact)

SUMMARY The Sales Fact table contains all business sales transactions from business year 2010/11 onwards. The presentation table contains surrogate keys which link to all relevant dimensions such as Date and Pub, to allow Sales to be grouped and analysed by attributes in these dimensions


Fact.Cost of Sales (Cost of Sales Fact)

SUMMARY The Cost of Sales Fact table contains the component products of sales made, and the cost of their purchase. The relationship between the Cost of Sales and Sales tables is many-to-one. The relationship is also at transaction level, because component parts of e.g. a recipe and their cost can change over time and between pubs, so may be unique to a sale at that time. The sum of costs in the Fact.CostofSales for a transaction should always equal the summary COS figure in Fact.Sales for that transaction.

The presentation table contains surrogate keys which link to all relevant dimensions such as Date, RetailProduct and StockProduct, to allow Costs and Purchased products to be grouped and analysed by attributes in these dimensions