Summary
This chapter covered the processes for designing physical storage for your cube. You learned about the capabilities of the three core storage modes—MOLAP, HOLAP, and ROLAP—and about aggregation design and partitioning. Remember that several of these features require the Enterprise Edition of SSAS, as noted for each feature in the text of this chapter.
The most important consideration for physical cube storage design is to get the correct balance between performance and manageability. Many customers are satisfied with MOLAP for their entire cubes, with just a bit of added custom-designed aggregations.
In the next chapter, we'll venture into the world of SSIS. You'll learn how to design basic SSIS packages, and in the process, you'll learn ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
