Question

3. (2 points) (OLAP Operations) Assume we have a data cube consists of three dimensions: Product, Time and Location. The values (i.e., facts) show the revenue in thousand dollars. Product Printer DVD Time 2/3/2010 3/3/2010 Ottawa 100 80 70 20 35 21 20 40 Assume we have the following hierarchy: TIME LOCATION year country month province date city Location Which OLAP operations should be performed in order to answer the following questions: a) [1 point] Total revenue earned by selling DVD in British Columbia in 2010. b) [1 point] Total revenue earned by each product in each province.

          3. (2 points) (OLAP Operations) Assume we have a data cube consists of three dimensions:
Product, Time and Location. The values (i.e., facts) show the revenue in thousand dollars.
Product
Printer
DVD
Time
2/3/2010
3/3/2010
Ottawa
100 80 70
20 35 21 20
40
Assume we have the following hierarchy:
TIME
LOCATION
year
country
month
province
date
city
Location
Which OLAP operations should be performed in order to answer the following questions:
a) [1 point] Total revenue earned by selling DVD in British Columbia in 2010.
b) [1 point] Total revenue earned by each product in each province.

3. (2 points) (OLAP Operations) Assume we have a data cube consists of three dimensions:
Product, Time and Location. The values (i.e., facts) show the revenue in thousand dollars.
Product
Printer
DVD
Time
2/3/2010
3/3/2010
Ottawa
100 80 70
20 35 21 20
40
Assume we have the following hierarchy:
TIME
LOCATION
year
country
month
province
date
city
Location
Which OLAP operations should be performed in order to answer the following questions:
a) [1 point] Total revenue earned by selling DVD in British Columbia in 2010.
b) [1 point] Total revenue earned by each product in each province.

Added by Jack M.

Question

Please give Ace some feedback