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. What MDX DDL extensions are required for creating a local cube?
2. Your cube contains a Geography dimension that has the levels Region and City. The regions are Eastern, Central, and Western. Each region contains several cities. How can you specify the names of the regions on an axis in your MDX statement?
3. Using the scenario in the previous question, how can you list all of the regions and cities on the same axis?
4. You want to create tuples that combine all cities in the Eastern region and the years 1997 and 1998 on the COLUMNS axis. How can you do this without explicitly listing each combination?
5. Your cube contains two measures, ListPrice and Cost, about the items you sell. You want to include a calculated value, which is not a measure in the cube, in a report. How can you do this?
6. Describe the steps you should follow to create a local cube containing information for cost by region for each quarter in 1997. The default measure for the source cube is [Total Sales].
7. You need to build an application that presents the contents of a cube on a Web page. How can you populate a PivotTable Service-style chart with individual cell values?
8. Users want to build new OLAP cubes to address a particular business scenario. A single user will use these new cubes. How can you provide this functionality?
9. Write a query that reads the quarterly unit sales for each store in the state of Washington.
10. How do you return the first cell in a cellset?
11. Name the Cellset object property that contains the slicer dimensions.

Answers