Review

The following questions are designed to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A: Questions and Answers.

1. How would a Microsoft Excel user configure a new data cube on a local workstation so that she could work on the data without connecting to the server?
2. You need to build a custom client application that will allow users to build new cubes that will reside on the OLAP Server and be accessible to all users. How should you do this?
3. You need to build an application that prints out the dimensions and hierarchies within an existing cube. How should you do this?
4. Name the parts of a multidimensional schema.
5. Name the objects that represent multidimensional schema information.

Answers