Suppose Fox Lake wants to analyze member charges using an OLAP cube. Thinking about all of the club’s activities (tennis, golf, swimming, restaurant, lessons, and pro shop), answer the following questions.

a. Define appropriate measures for this cube.

b. Suppose Fox Lake defines Year, Quarter, Month, and DayOfWeek dimensions (the OLAP server can construct these using the date of the expense). Explain the meaning of the measures you identified in part a if the columns of the cube are ordered as DayOfWeek, Quarter, Year. What is the meaning if the columns are ordered Year, DayOfWeek, Quarter?

c. Create a mockup of an OLAP cube that Fox Lake could use to assess which club activities generate the most business in the early spring and late fall.

Assume you are interested in determining whether weekday specials are a good idea. How would you use the cube to determine whether the desirability of weekday specials differs among activities or times of the year?