更新时间：2021-08-13 18:03:20
coverpage
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Designing the Data Warehouse for Analysis Services
The source database
Data modeling for Analysis Services
Physical database design for Analysis Services
Summary
Chapter 2. Building Basic Dimensions and Cubes
Multidimensional and Tabular models
Choosing an edition of Analysis Services
Setting up a new Analysis Services project
Creating data sources
Creating Data Source Views
Designing simple dimensions
Building a simple cube
Chapter 3. Designing More Complex Dimensions
Grouping and banding
Modeling Slowly Changing Dimensions
Modeling junk dimensions
Modeling ragged hierarchies
Chapter 4. Measures and Measure Groups
Measures and aggregation
Measure groups
Dimension/measure group relationships
Chapter 5. Handling Transactional-Level Data
Details about transactional data
Drillthrough
Many-to-many dimension relationships
Chapter 6. Adding Calculations to the Cube
Different kinds of calculated members
Common calculations
Calculation dimensions
Named sets
Chapter 7. Adding Currency Conversion
Introduction to currency conversion
Where to perform currency conversion
The Add Business Intelligence wizard
Measure expressions
Chapter 8. Query Performance Tuning
Understanding how Analysis Services processes queries
Performance tuning methodology
Designing for performance
Performance-specific design features
MDX calculation performance
Caching
Scale-up and Scale-out
Chapter 9. Securing the Cube
Sample security requirements
Analysis Services security features
Administrative security
Data security
Dynamic cell security
Accessing Analysis Services from outside a domain
Managing security
Security and query performance
Chapter 10. Going in Production
Making changes to a cube in production
Managing partitions
Managing processing
SSAS Data Directory maintenance
Performing database backup
Copying databases between servers
Chapter 11. Monitoring Cube Performance and Usage
Analysis Services and the operating system
Monitoring processing performance
Monitoring query performance
Monitoring usage
Building a complete monitoring solution
Appendix A. DAX Query Support
Implementation details
Connecting Power View to a Multidimensional model
Running DAX queries against a Multidimensional model
Index
