Chapter 3. Building Your First Cube

After completing this chapter, you will be able to:

  • Navigate an Analysis Services project in Microsoft Visual Studio.

  • Use the Cube Wizard to build a simple cube from a template.

  • Use the Generate Schema Wizard to build a relational schema as a data source for the cube.

  • Deploy and process an Analysis Services project to the Analysis Server.

  • Browse a cube.

In Chapter 2, you were introduced to the key components of an Analysis Services cube and the role of a cube in a business intelligence (BI) solution. Now you’re ready to learn how to build a cube by using the business intelligence templates available in Microsoft Visual Studio. In this chapter, you’ll begin by familiarizing yourself with the organization of objects ...

Get Microsoft® SQL Server™ 2005 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.