O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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 9. Processing Cubes and Dimensions

Now that you have developed and refined an OLAP cube, it’s time to learn how to build and process Microsoft SQL Server 2008 Analysis Services (SSAS) objects and deploy them from the Business Intelligence Development Studio (BIDS) environment to the SSAS server. To enable you to understand what steps are involved in cube and dimension processing, we’ll first define the two different types of information that you’ll work with in creating OLAP cubes: metadata and cube data. Then we’ll explain aggregations and examine the role that XMLA plays in creating OLAP cubes and dimensions. We’ll close the chapter with a detailed look at the possible cube data storage modes: multidimensional OLAP (MOLAP), hybrid 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