O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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 16. Advanced OLAP

Andrew Brust

In the previous chapter, you learned the basic concepts and vocabulary of online analytical processing (OLAP) and learned how to create your own cube, based on the Northwind database. Building a cube from scratch gives you an understanding of OLAP that would be hard to acquire by merely studying the Adventure Works sample cube supplied with Microsoft SQL Server 2008. After going through Chapter 15’s process of creating a fact table and dimension tables and then designing, creating, and querying a cube in the cube browser, you should have a sense of the relative ease and power of using OLAP. As a result, you should be able to dispense with the trepidation that many people experience when they approach OLAP. ...

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