Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Business Management Expert

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?

 

Business Management, Management Studies

  • Category:- Business Management
  • Reference No.:- M91568460
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in Business Management

Which of the listed qualities of leaders and managers did

Which of the listed qualities of leaders and managers did the nurse manager display? Which behaviors? Which ones did the nurse manager not display?

Why is federal income tax important to a company can it

Why is federal income tax important to a company? Can it effect the hiring process for employees?

Assume that the car lot contains 25 percent porches 35

Assume that the car lot contains 25 percent Porches, 35 percent BMWs, and 40 percent Volvos. Of the Porches, 20 percent have navigation systems, 90 percent of the BMWs have navigation systems, and 70 percent of the Volvo ...

We were discussing the concept of systems thinking and how

We were discussing the concept of Systems thinking and how it is essentially learning about oneself in interaction with the surrounding world How do you applying this concept to the work environment,

Decision support systems dss what sorts of dss tools do you

Decision support systems (DSS). What sorts of DSS tools do you use at your work - e.g., what-if analysis, sensitivity analysis, scenario analysis, goal-seeking analysis, optimization analysis, etc.? Even if you don't use ...

Do you think there is some type of diversity we really

Do you think there is some type of diversity we really aren't interested in? Or, perhaps what we really are looking for is an end to discrimination, but at some point in the last 10-15 years that has morphed into the con ...

Ricardo the ceo of sunflower organics hires a consultant

Ricardo, the CEO of Sunflower Organics, hires a consultant, Saadia, to analyze his production process. Ricardo has been using the same production process for the nearly twenty years he's been in business. His employees a ...

Sumco a company that sells pump housings to manufacturers

Sumco, a company that sells pump housings to manufacturers, would like to reduce its inventory cost by determining the optimal number of pump housings to obtain per order. The annual demand is 1,000 units, the ordering c ...

A producer of chairs is considering the addition of a new

A producer of chairs is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $9000 per month and a variable costs of 60 c ...

Were canals and toll roads public goods describe the

Were canals and toll roads public goods? Describe the process of financing and building canals and roads in antebellum period. What was the effect on economic growth?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As