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

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

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