PacktLib: Expert Cube Development with SSAS Multidimensional Models

Expert Cube Development with SSAS Multidimensional Models

Credits

About the Authors

About the Reviewers

www.PacktPub.com

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

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

Designing More Complex Dimensions

Grouping and banding

Modeling Slowly Changing Dimensions

Modeling junk dimensions

Modeling ragged hierarchies

Summary

Measures and Measure Groups

Measures and aggregation

Measure groups

Dimension/measure group relationships

Summary

Handling Transactional-Level Data

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

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

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

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

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

DAX Query Support

DAX Query Support

Index