Many of the recommendations for designing cubes we've given so far in this book have been given on the basis that they will improve query performance, and in fact the performance of a query is intimately linked to the design of the cube it's running against. For example, dimension design, especially optimizing attribute relationships, can have a significant effect on the performance of all queries—at least as much as any of the optimizations described in this chapter. As a result, we recommend that if you've got a poorly performing query the first thing you should do is review the design of your cube (along with the relevant chapters of this book) to see if there is anything you could do differently. There may well be some kind of trade-off needed between usability, manageability, time-to-develop, overall 'elegance' of the design and query performance, but since query performance is usually the most important consideration for your users then it will take precedence...
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