Chapter 9. Exploring Special Features

After completing this chapter, you will be able to:

  • Use a referenced dimension.

  • Define a many-to-many dimension.

  • Add and browse translations for attributes and measures.

  • Create perspectives for different types of users.

In Chapter 8, you learned how to customize a cube by adding calculations as new measures and as new dimension members, as well as by manipulating calculations through sequencing and through script assignments. In this chapter, you’ll further customize your solution by using advanced dimension design techniques and by addressing the special requirements of businesses working in a global economy. Then you’ll learn how to organize a cube so that users can focus on a particular type of analysis without ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step 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.