Question: Consider the common OLAP operations: slice , dice , roll-up , drill-down , pivo t. For each question (query) below, identify which operation(s) are needed

Consider the common OLAP operations: slice , dice

Consider the common OLAP operations: slice, dice, roll-up, drill-down, pivot. For each question (query) below, identify which operation(s) are needed to obtain the answer.

  1. When (month) is the highest total expenditure?
  2. Are restaurant expenditures higher in Toronto in the first quarter or the third quarter?
Consider the following data cube. Month - Dec. Category = Vehicle Region = Two Amount = 6720 Count = 110 Dec. Nov. Oct. Sep Aug Jul. Month- Jun. May Apr. Mar. Feb. Four Three Jan. Two one Travel Vehicle Retail Supermarket Region Restaurant Miscellaneous Category

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:

INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently...

Q:

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Q:

I've attached the question as a word file, thanks! JWCL165_c10_444-505.qxd 8/12/09 7:24 AM Page 444 10 Liabilities Chapter STUDY OBJECTIVES After studying this chapter, you should be able to: 1...

Q:

I've attached the question as a word file, thanks! JWCL165_c10_444-505.qxd 8/12/09 7:24 AM Page 444 10 Liabilities Chapter STUDY OBJECTIVES After studying this chapter, you should be able to: 1...

Q:

Lets consider the following OLAP operations from 1 to 5 To do : rewrite these operations by using the syntax introduced in lab4 Lets consider the following OLAP operations from 1 to 5 To do : rewrite...

Q:

1-Classify the major issues associated with designing a data warehouse database. 2-Discuss the activities associated with each of four primary data flows or processes within a data warehouse. 3-What...

Q:

ANSWER THROUGHLY Q 3 . ( 2 5 points ) [ OLAP Operations ] Assume we have a data cube with the following three dimensions: Store, Time, and Product. The values ( i . e . , facts ) represent the total...

Q:

Type or paste question here PE Diesen Bewe 1. From figure 1, state the entity entity relationships. 6. From Eure 2, what are the measurez bere? State which are Additive, semi-additive, and...

Q:

Q 3 . ( 2 5 points ) [ OLAP Operations ] Assume we have a data cube with the following three dimensions: Store, Time, and Product. The values ( i . e . , facts ) represent the total number of items...

Q:

Which statement is incorrect on OLAP? a. MOLAP scales better to more dimensions than ROLA b. MOLAP physically stores data into a data cube for OLAP operations. c. ROLAP accesses the data stored in a...

Q:

Listed below are several terms and phrases associated with the FASBs conceptual framework. Pair each item from List A (by letter) with the item from List B that is most appropriately associated with...

Q:

Textile Mills borrows money at a rate of 1 3 5 percent. This interest rate is referred to as the: Select one: a . compound rate. b . current yield. c . cost of debt. d . capital gains yield. e . cost...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...