PacktLib: Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Credits

About the Authors

About the Reviewers

Preface

Designing the Data Warehouse for Analysis Services

The source database

Data modeling for Analysis Services

Physical database design for Analysis Services

Summary

Building Basic Dimensions and Cubes

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

Designing More Complex Dimensions

Grouping and Banding

Slowly Changing Dimensions

Junk dimensions

Ragged hierarchies

Summary

Measures and Measure Groups

Measures and aggregation

Measure groups

Dimension/measure group relationships

Summary

Adding Transactional Data such as Invoice Line and Sales Reason

Details about transactional data

Drillthrough

Many-to-many dimension relationships

Summary

Adding Calculations to the Cube

Different kinds of calculated members

Common calculations

Calculation dimensions

Named sets

Summary

Adding Currency Conversion

Introduction to currency conversion

Where to perform currency conversion

The Add Business Intelligence Wizard

Measure expressions

Summary

Query Performance Tuning

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

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

Productionization

Making changes to a cube in production

Managing partitions

Managing processing

Analysis Services data directory maintenance

Backup

Copying databases between servers

Summary

Monitoring Cube Performance and Usage

Analysis Services and the operating system

Monitoring processing performance

Monitoring query performance

Monitoring usage

How to build a complete monitoring solution

Summary

Index