tutorial 4 (Hierarchic) Consider a SALES data warehouse, with only 2 dimensions (Time and Products), where the fact table contains the total daily sales of all products. Assume the Time dimension has attributes (Time_Id, Day, Week, Month, Quarter, Year) and the Product dimension has attributes (Product_Id, Product_Description). You may need to answer any of the following ad-hoc queries - For all Products get sales at the Day, or aggregate at the Month or Year levels - For all Products get sales at the Day, or aggregate at the Week or Quarter levels - For all Products get sales at the Day, or aggregate at the Quarter or Year levels - Draw the data warehouse scheme - What Rollup hierarchy are needed? - Draw those hierarchies? - Write down the Oracle statements needed for creating such hierarchies? - Suppose the fact table has the total daily sales of products for only 1 year and 200 products (it has 365200 basic records). How many aggregated records will be added to the data warehouse's fact table? (Show the details of your Answers)