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.
Expert Cube Development with SSAS Multidimensional Models
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
Free Chapter
Designing the Data Warehouse for Analysis Services
Building Basic Dimensions and Cubes
Designing More Complex Dimensions
Measures and Measure Groups
Handling Transactional-Level Data
Adding Calculations to the Cube
Adding Currency Conversion
Query Performance Tuning
Securing the Cube
Going in Production
Monitoring Cube Performance and Usage
DAX Query Support
Index
Customer Reviews