1.Given the ERD at the end of this assignment, design an OLAP cube model that will answer questions about sales person effectiveness in selling products. Identify the facts/measures and whether they are additive or not; and dimensions (at least 4) and their attributes and any hierarchies within the attributes. Also identify the grain of the cube. Document the cube structure using a star schema diagram.

Sales Regi Custom varcharl50M Store Name varchar(50 Add varchar(70 Address var chart70 varchar(50 State char(2 Zip varchar Contactperson varchar(70 ContactNumber warcharl30 var chart70 FK1 Region Number inyint FK2 Sales Order Date date FRK2 Store int Subtotal S&H Tota Purchase FRK1 Sales PersonlD Order Details PK Detail FK2 ProductID HO K1 OrderID allets Quantity allet money Subtotal TaxSubtotal Salespeople PK SalesetersonLD Int varchar 400 varchar 40 DateEmpl oyment started date FK1 AssignedRegi PIK ProductID Model Number varchar 20) varchar(100) Product Desc varchar 1200 varchar 20) CurrentRetailPricePerpallet smallmoney Sales Regi Custom varcharl50M Store Name varchar(50 Add varchar(70 Address var chart70 varchar(50 State char(2 Zip varchar Contactperson varchar(70 ContactNumber warcharl30 var chart70 FK1 Region Number inyint FK2 Sales Order Date date FRK2 Store int Subtotal S&H Tota Purchase FRK1 Sales PersonlD Order Details PK Detail FK2 ProductID HO K1 OrderID allets Quantity allet money Subtotal TaxSubtotal Salespeople PK SalesetersonLD Int varchar 400 varchar 40 DateEmpl oyment started date FK1 AssignedRegi PIK ProductID Model Number varchar 20) varchar(100) Product Desc varchar 1200 varchar 20) CurrentRetailPricePerpallet smallmoney