05 Dee Clark, the marketing manager at Emerson Pharmaceuticals, wants to place an OLAP report on her blog. Assume each salesperson reports to a district manager, each district manager reports to one of seven regional managers, and the regional managers report to the vice president of sales. Further assume that Emerson reports the total sales for each product family for each salesperson for each month.

a. Define the measure and dimensions of an OLAP cube for this situation.

b. Using hypothetical data, show how the cube would appear if the dimensions are organized by Region, Territory, and Product Family, in that order.

c. Using hypothetical data, show how the cube would appear if the dimensions are organized by Product Family, Region, and Territory, in that order.

d. Under what conditions would a salesperson

(who is accessing this report on Dee’s blog) be interested in the display in part b?

e. Under what conditions would a salesperson be interested in the display in question c?

f. Would it be important for Dee to disallow reporting the sales by salesperson? Explain.