Look at the discription

maryal11

A multinational business, say McDonalds wants to keep control on their business. They built a DW, and among the cubes which they have included in the design are: Purchasing, Sales, Exchange Rates and Inventory. The Exchange Rates cube can be defined as follows: Exchange Rates((Day, Bank, Country), (Buy$_Opening, Buy$_Closing, Buy$_Average, Sell$_Opening, Sell$_Closing, Sell$_Average)).

1. Establish the dimensions and measures you consider necessary for the rest of 3 cubes and then define these 3 cubes (as done for the Exchange Rates cube)

2. Draw the ME/R diagram for the 4 cubes. You may choose the granularity levels of the dimensions as you consider fit.

3. Draw the lattice of cuboids for the Exchange Rates cube.

4. How many nodes does the lattice of cuboids have for a cube with n dimensions?

    • 10 years ago
    • 15
    Answer(0)
    Bids(0)