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