Chapter 5. Creating a Cube

In this chapter, you will learn how to:

  • Create a cube using the Cube Wizard.

  • Modify a cube using the Cube Designer.

  • Combine data with different dimensionality and granularity in a single cube.

  • Rename and format measure groups and measures.

  • Add measure groups, measures, and calculated members to an existing cube.

  • Browse a cube using the Cube Designer browser.

In Chapter 4, you learned how to create standard, time, and parent-child dimensions. In this chapter, you use the Cube Wizard to combine these dimensions with numeric data in a cube. You then use the Cube Designer to modify the cube to make it more user-friendly, add measures and calculations, and enhance its functionality. You also use a browser to view the data in the ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.