Name: Expert Cube Development with SSAS Multidimensional Models
Author: Chris Webb Alberto Ferrari Marco Russo
ISBN: 9781849689915

微信读书书城Expert Cube Development with SSAS Multidimensional Models

首页我的书架登录

翻译完成

切换

Expert Cube Development with SSAS Multidimensional Models

Chris Webb Alberto Ferrari Marco Russo

扉页
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
Summary
Chapter 3. Designing More Complex Dimensions
Grouping and banding
Modeling Slowly Changing Dimensions
Modeling junk dimensions
Modeling ragged hierarchies
Summary
Chapter 4. Measures and Measure Groups
Measures and aggregation
Measure groups
Dimension/measure group relationships
Summary
Chapter 5. Handling Transactional-Level Data
Details about transactional data
Drillthrough
Many-to-many dimension relationships
Summary
Chapter 6. Adding Calculations to the Cube
Different kinds of calculated members
Common calculations
Calculation dimensions
Named sets
Summary
Chapter 7. Adding Currency Conversion
Introduction to currency conversion
Where to perform currency conversion
The Add Business Intelligence wizard
Measure expressions
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Appendix A. DAX Query Support
Implementation details
Connecting Power View to a Multidimensional model
Running DAX queries against a Multidimensional model
Index

简介

版权

Expert Cube Development with SSAS Multidimensional Models