Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

Summary

This chapter covered the processes for adding more power to your cube. We reviewed the processes for adding KPIs, translations, perspectives, and actions. Remember that several of these features require the Enterprise Edition of SSAS (and the Enterprise AdventureWorks 2008 R2 samples) as noted in this chapter. The other critical consideration with these features is to verify that all end-user client applications support whatever features you want to add to your cube.

In Chapter 5, we'll delve even deeper into the complexities of SSAS cube modeling. We'll discuss several features, such as the use of multiple fact tables and advanced dimension types (including many-to-many dimensions). We'll also take a more detailed look at the Business ...