Given the ERD below, 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 Regions PK Re tinyint U1 Region Name varchar (20) Customer Stores PK Storelo Store Chain varchar (50) varchar (50) StoreName Address varchar (70 varchar(70) Address2 varchar (50) City char(2) State varchar (15) Zip ContactPerson varchar (70 ContactNumber varchar (30) Contact Email varchar(70 FK1 Region Number tinyint FK2 Sales Person ID nt Orders PK orderD char(10) Order Date date FK2 StorelD nt Subtotal money Tax money S&H money Tota Purchase money FK1 Sales PersonID nt OrderDetails FK2 ProductID nt FK1 OrderID nt Quantity Pallets int SalePricePerPallet money Subtota money Tax Subtotal money Sales People Int PK Sales PersonlD varchar (40) Last name varchar (40) First name Date EmploymentStarted date FK1 Assigned Region tinyint Products PK Product ID int Model umber varchar(20) varchar(100) Product Name varchar (200) Product Desc varchar(20) SKU Current Retail PricePerPallet smallmoney