Microsoft SQL Server 2005 Analysis Services Step by Step

Introduction;
Finding Your Best Starting Point;
About the Companion CD-ROM;
System Requirements;
Installing and Using the Sample Files;
Conventions and Features in This Book;
Part I: Getting Started with Analysis Services;
Chapter 1: Understanding Business Intelligence and Data Warehousing;
Introducing Business Intelligence;
Reviewing Data Warehousing Concepts;
Chapter 1 Quick Reference;
Chapter 2: Understanding OLAP and Analysis Services;
Understanding OLAP;
Understanding Analysis Services;
Chapter 2 Quick Reference;
Chapter 3: Building Your First Cube;
Exploring Business Intelligence Development Studio;
Preparing to Create a Cube;
Creating a Cube;
Generating a Schema;
Processing and Browsing a Cube;
Chapter 3 Quick Reference;
Part II: Design Fundamentals;
Chapter 4: Designing Dimensions;
Reviewing the Data Warehouse Structure;
Building a Standard Dimension;
Working with a Time Dimension;
Creating a Parent-Child Dimension;
Chapter 4 Quick Reference;
Chapter 5: Designing Measure Groups and Measures;
Adding Measure Groups to a Cube;
Aggregating Semiadditive Measures;
Calculating Distinct Counts;
Creating Simple Calculations;
Chapter 5 Quick Reference;
Chapter 6: Working with a Finance Measure Group;
Designing an Account Dimension;
Designing Nonadditive Financial Measures;
Chapter 6 Quick Reference;
Chapter 7: Designing Aggregations and Hierarchies;
Understanding Aggregation Design;
Designing User Hierarchies;
Optimizing Aggregations;
Chapter 7 Quick Reference;
Part III: Advanced Design;
Chapter 8: Using MDX;
Creating Tuple-Based Calculated Members;
Querying with MDX;
Designing Custom Members;
Working with MDX Scripts;
Developing Key Performance Indicators;
Chapter 8 Quick Reference;
Chapter 9: Exploring Special Features;
Defining Dimension Relationships;
Supporting Currency Conversions;
Localizing Cubes;
Organizing Information with Folders and Perspectives;
Chapter 9 Quick Reference;
Chapter 10: Interacting with Cubes;
Implementing Actions;
Using Writeback;
Chapter 10 Quick Reference;
Part IV: Production Management;
Chapter 11: Implementing Security;
Using Role-Based Security;
Applying Security to a Dimension;
Securing Data at the Cell Level;
Setting Administration Security;
Chapter 11 Quick Reference;
Chapter 12: Managing Partitions and Database Processing;
Managing Very Large Databases;
Working with Storage;
Managing OLAP Processing;
Monitoring Cube Activity;
Chapter 12 Quick Reference;
Chapter 13: Managing Deployment;
Reviewing Deployment Options;
Managing Database Objects Programmatically;
Automating Database Processing;
Planning for Disaster and Recovery;
Chapter 13 Quick Reference;
Glossary;
Appendix : About the Authors;
Contributing Authors;