Chapter 4. Using SSAS
Now that you've seen the big picture of BI solutions in Chapter 1, been introduced to OLAP modeling for SSAS in Chapter 2, and been introduced to ETL and SSIS in Chapter 3, it's time to start working with SSAS to build your first cube. It is quite common to prototype cubes built on subsets of enterprise data quickly in a BI project. As with any other type of development, you can expect cube development to be iterative. Generally, ETL development runs somewhat concurrently to these cube iterations, assuming that you have the resources to commit to both of these processes.
This chapter assumes you have a couple of populated star schemas in SQL Server to work with. The data in the samples are, of course, "very clean." This is ...
Get Foundations of SQL Server 2005 Business Intelligence 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.
