Question: Consider the data cube shown on slide 1 1 and slide 1 2 in the lecture. Suppose we want to know whether restaurant expenditures are
Consider the data cube shown on slide and slide in the lecture. Suppose we want to know whether restaurant expenditures are higher in Region One in the first quarter or the third quarter. What OLAP operations should be apply?A Slice with Region One and Category Restaurant; roll up on Months frommonths to quarters.O B Slice with Category Restaurant and Region One; Drill down from year toquarters.C Dice with Region One and Months Jan, Feb, Mar, Jul, Aug, Sep; Slice withCategory Restaurant.D Dice with Region One and Category Restaurant; roll up on Months frommonths to quarters.E Pivot with Region One and Category Restaurant; Set value for quartersequal to maximum.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
