O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

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 Building an Analysis Services Database

Now that we have invested the time and effort to build a robust data warehouse and data-integration process, we can add the final piece to the solution: the on-line analytical processing (OLAP) database. Flexible analytical capabilities are required to really take advantage of the integrated information in the data warehouse and move beyond a simple level of understanding such as measuring the increase in income received.

In this chapter, we extend the manufacturing solution from the previous two chapters by building an Analysis Services database to enable users to flexibly access the information in the data warehouse. We describe how to adjust the data model to better support cubes and ...

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