Professional SQL Server^TM Analysis Services 2005 with MDX

by Sivakumar Harinath; Stephen R. Quinn

• ISBN13: 9780471927198
• ISBN10: 0471927198
• Format: eBook
• Copyright: 2006-04-01
• Publisher: Wrox

Summary

Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases The authors then describe the development processes for building dimensions and cubes from various data sources Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

Table of Contents

Acknowledgments

Introduction

Introduction

Introduction to Data Warehousing and Analysis Services 2005

First Look at Analysis Services 2005

Introduction to MDX

Working with Data Sources and Data Source Views

Dimension Design

Cube Design

Advanced Topics

Advanced Topics in MDX

Advanced Dimension Design

Advanced Cube Design

Extending MDX using External Functions

Administration, Performance Tuning Integration

Updating Your UDM Data

Administering Analysis Services

Performance Optimization

Data Mining

Analyzing Cubes using Office Client Components

Integration Services

Scenarios

Reporting Services

Designing Real-Time Cubes

Securing Your Data in Analysis Services

Appendix: MDX Function and Operator

Reference

Index

Table of Contents provided by Publisher. All Rights Reserved.