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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.