CHAPTER 11

image

Creating and Configuring SSAS Cubes

Once I completed the cube and demonstrated it to my students, I realized it was nearly impossible to put down.

—Erno Rubik

In the previous two chapters, we prepared dimensions for our cube (or cubes, if you are creating a BI solution that uses more than one). Now it is time to make the cube and find out whether the cube and dimensions are presenting the right report data. We then resolve any issues using common SSAS configurations.

In this chapter, you learn how to create and configure Analysis Server cubes. We show you how to configure the cubes using Business Intelligence Development Studio and ...

Get Pro SQL Server 2012 BI Solutions now with O’Reilly online learning.

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