Book Image

Expert Cube Development with SSAS Multidimensional Models

By : Alberto Ferrari, Marco Russon, Chris Webb
Book Image

Expert Cube Development with SSAS Multidimensional Models

By: Alberto Ferrari, Marco Russon, Chris Webb

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

The Add Business Intelligence wizard


The Add Business Intelligence wizard can be used to implement currency conversion in a cube; you can find it under the Cube menu by clicking on the menu option Add Business Intelligence and then, on the second step of the resulting wizard, selecting the Define Currency Conversion option. This wizard leverages Analysis Services features that are available in both Standard and Enterprise editions, such as MDX Script calculations. We can achieve the same result without using the wizard, or we can modify the objects and code produced by the wizard so they do what we want.

Concepts and prerequisites

Before using the wizard, we have to model our cube so that we have:

  • A Currency dimension:

    • The Type property of the dimension must be set to Currency

    • The Type property of one attribute for the dimension must be set to CurrencyName

    • The IsAggregatable property must be set to False for the key attribute

  • A Time dimension:

    • The Type property of the dimension must be set to Time...