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