O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required