Q1: Suppose you have a data warehouse of 4 dimensions: customers, location (county), product category (home appliances,
Posted: Thu May 26, 2022 8:39 am
- Q1 Suppose You Have A Data Warehouse Of 4 Dimensions Customers Location County Product Category Home Appliances 1 (71.85 KiB) Viewed 9 times
Q1: Suppose you have a data warehouse of 4 dimensions: customers, location (county), product category (home appliances, furniture, textile), time (month). The fact table is centered on the number of products sold. What type of OLAP operation is needed to find the following information (slice, dice, roll-up, drill down) 1) The number of products sold in the Middle East. 2) The number of products bought by customer (XYZ). 3) The number of air conditioners sold in Amman and Aqaba during Summer this year.