Book Image

Expert Cube Development with SSAS Multidimensional Models

Book Image

Expert Cube Development with SSAS Multidimensional Models

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


In this chapter, we have seen many ways to enhance our cube by adding calculations to it. Let us briefly recall them:

  • Calculated Measures create new measures whose value is calculated using MDX expressions. The new measures will be available as if they are real measures, although they do not support drillthrough.

  • Calculation dimensions allow us to apply a single calculation to all of the measures in our cube, avoiding the need to create multiple calculated measures.

  • Named sets allow us to predefine static or semi-static sets of members that in turn make building reports easier for our users.

In the next chapter, we'll move on to look at a much more complex, but nonetheless common type of calculation: currency conversion.