Book Image

Expert Cube Development with SSAS Multidimensional Models

Book Image

Expert Cube Development with SSAS Multidimensional Models

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Expert Cube Development with SSAS Multidimensional Models
Feb, 2014 | 402 pages
No titles found
Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Expert Cube Development with SSAS Multidimensional Models
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Designing the Data Warehouse for Analysis Services
Designing the Data Warehouse for Analysis Services
The source database
Data modeling for Analysis Services
Physical database design for Analysis Services
Summary
2
Building Basic Dimensions and Cubes
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
3
Designing More Complex Dimensions
Designing More Complex Dimensions
Grouping and banding
Modeling Slowly Changing Dimensions
Modeling junk dimensions
Modeling ragged hierarchies
Summary
4
Measures and Measure Groups
Measures and Measure Groups
Measures and aggregation
Measure groups
Dimension/measure group relationships
Summary
5
Handling Transactional-Level Data
Handling Transactional-Level Data
Details about transactional data
Drillthrough
Many-to-many dimension relationships
Summary
6
Adding Calculations to the Cube
Adding Calculations to the Cube
Different kinds of calculated members
Common calculations
Calculation dimensions
Named sets
Summary
7
Adding Currency Conversion
Adding Currency Conversion
Introduction to currency conversion
Where to perform currency conversion
The Add Business Intelligence wizard
Measure expressions
Summary
8
Query Performance Tuning
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
9
Securing the Cube
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
10
Going in Production
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
11
Monitoring Cube Performance and Usage
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
DAX Query Support
DAX Query Support
Implementation details
Connecting Power View to a Multidimensional model
Running DAX queries against a Multidimensional model
Index
Index

Credits

Authors

Chris Webb

Alberto Ferrari

Marco Russo

Reviewers

Sean O'Regan

James Serra

Dr. John Tunnicliffe

Jen Underwood

Roger D Williams Jr

Acquisition Editors

James Lumsden

Kartikey Pandey

Joanne Fitzpatrick

Content Development Editor

Chalini Snega Victor

Technical Editors

Manan Badani

Shashank Desai

Shali Sasidharan

Project Coordinator

Kranti Berde

Proofreaders

Simran Bhogal

Maria Gould

Ameesha Green

Paul Hindle

Indexers

Monica Ajmera Mehta

Rekha Nair

Tejal Soni

Graphics

Ronak Dhruv

Valentina Dsilva

Abhinash Sahu

Production Coordinator

Arvindkumar Gupta

Cover Work

Arvindkumar Gupta

Previous Section
Next Chapter