Question: PLEASE ANSWER CORRECTLY FOR A THUMBS UP (2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions: Item, Time and Location.
![PLEASE ANSWER CORRECTLY FOR A THUMBS UP (2 points) [OLAP Operations]](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/10/671cc0437e995_474671cc04307380.jpg)
PLEASE ANSWER CORRECTLY FOR A THUMBS UP
(2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions: Item, Time and Location. The values (i.e., facts) show the revenue in thousand dollars. Assume we have the following hierarchy: Which OLAP operations should be performed in order to answer the following questions: a) [1 point] Total revenue earned by selling Mobil and Modem in Canada in Q1. b) [1 point] Total revenue earned by each Item in each Quarter
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
