Additive Fact
Additive fact can summarize and added across all dimensions around fact table. Transaction level fact table must be design with Additive facts.
An instance, the business process is “SALES” then the Transactional Sales Fact table might be design with Date_Key, Store_Key, Product_Key, Promotion_Key, Customer_Key, Employee_Key, Invoice_Number, Sales_QTY, Extended_Price and Discount_Amount attributes.
Sales_QTY, Extended_Price and Discount_Amount attributes are additive facts that used to stores Sales measurement data.
The combination of Date_Key, Store_Key, Product_Key, Promotion_Key, Customer_Key, Employee_Key, Invoice_Number is composite primary key of Sales_Fact table and those attributes are integrates with Date, Store, Product, Promotion, Customer, Employeee and Invoice dimension tables.
Sales_Fact table and relevant dimension tables are help to generate Date wise, Store wise, Product wise, Customer wise and Employee wise Transactional Sales Analysis Report from Sales Historical Information.
Next >>
Your Comment To AUTHOR |
|