Question: Assume we have a data cube consisting of three dimensions: Product, Time, and Location. The values ( i . e . , facts ) show

Assume we have a data cube consisting of three dimensions: Product, Time, and Location. The values (i.e., facts) show the revenue in thousands of dollars. Which OLAP operations should be performed in order to answer the following questions: a.) Total revenue earned by selling DVDs in British Columbia in 2010. b.) Total revenue earned by each product in each province. Time 2/3/20103/3/2010 Toronto Ottawa Product PC Printer DVD 100907080|23|35212040182835 Location Victoria Vancouver 110896285 Assume we have the following hierarchy: TIME LOCATION year country month | date province | city

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

French Fragrances, Ltd. budgeted for 12,000 bottles of perfume Belle during May. The unit cost of Belle was $20, consisting of direct materials, $7; direct labor, $8; and factory overhead, $5 (fixed,...

Q:

Assume we have a data cube consisting of three dimensions: Item, Time and Location. The values ( i . e . , facts ) show the revenue in thousand dolla assume we have the heirarchy: Location Country =...

Q:

Please provide accurate answer with explanation for a and b. Will give a like. thanks (2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions: Product, Time and Location....

Q:

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. Assume that we have...

Q:

3. (2 points) [OLAP Operations] Assume that we have a data cube consists of three dimensions: Product, Time and Location. The values (i.e., facts) show the revenue in thousand dollars. Time 2/3/2010...

Q:

hierarchies 2/3/2010 3/3/2010 Time Location Toronto Product PC Printer DVD Year Ottawa 100 90 70 80 23 | 35 21 20 | 40 | 18 | 28 | 35 Location Victoria Month Country | Province | City Vancouver 110...

Q:

Time hierarchies 2/3/2010 3/3/2010 Time Toronto Location Year Ottawa Product TV PC Printer DVD 100 90 70 80 23 35 21 20 40 18 28 35 Location Victoria Vancouver Month Country 1 Province 1 City - 110...

Q:

Question 22 (1 point) Time hierarchies 2/3/2010 3/3/2010 Time Toronto Location Ottawa Country Product Printer DVD 100 90 70 80 23 | 35 | 21 | 20 40 | 18 | 28 | 35 110 89 62 85 Location Year 1 Month...

Q:

2- (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...

Q:

( 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...

Q:

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...

Q:

IN JAVA PLEASE. Complete the convert() method that casts the parameter from adouble to an integer and returns the result.Note that the main() method prints out the returned value of theconvert()...

Q:

Can a corporation's annual profit be predicted from information about the company's CEO? Each year Forbes publishes data on company profit (in $ millions), CEO's annual income (in $ thousands), and...

Q:

The duration of a 2 0 - year zero - coupon bond is d . equal to that of a 2 0 - year 1 0 % coupon bond. c . smaller than 2 0 . a . equal to 2 0 . b . larger than 2 0 .

Q:

The market leader for a low - involvement product must make special efforts to ?

Q:

(Appendices) Select a commonly used product, such as gasoline or milk, and track the prices of this product over a 20-year period by creating a line graph. Explain price increases and decreases based...

Q:

(Appendices) ADJUSTING ENTRY AND PREPARATION OF FINANCIAL STATEMENTS. Michaels Hardware has the following unadjusted trial balance at the end of 19x3: The following data are also available for...

Q:

(Appendices) PRESENTATION OF SALES REVENUE AND COST OF GOODS SOLD. The accountant for Sneva, Inc., collected the following data for 19x: LO3 REQUIRED: Assume that Sneva uses the periodic system and...