Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Understanding Business Intelligence and Analysis Services
Chapter 1 Business Intelligence: A Data Analysis Foundation
Introducing Business Intelligence
Multidimensional Data Analysis
Understanding a Dimensional Data Warehouse
Multidimensional OLAP
Chapter 2 Understanding OLAP and Analysis Services
Understanding OLAP
Understanding Analysis Services
Analysis Services and the Microsoft Business Intelligence Platform
Analysis Services Tools
Chapter 3 Accessing Source Data
Creating a Business Intelligence Solution
Creating a Data Source
Creating a Data Source View
Design Fundamentals
Chapter 4 Creating Dimensions
Previewing Dimension Data
Creating a Standard Dimension
Creating a Time Dimension
Creating a Parent-Child Dimension
Chapter 5 Creating a Cube
Previewing Cube Data
Using the Wizard to Create a Cube
Deploying and Browsing a Cube
Using the Cube Designer to Modify a Cube
Chapter 6 Creating Advanced Measures and Calculations
Using Aggregate Functions
Using MDX to Retrieve Values from a Cube
Creating Calculated Members
Calculation Scripting
Creating KPIs
Chapter 7 Advanced Dimension Design
Dimension Usage
Creating Reference Dimensions
Creating a Fact Dimension
Creating a Many-to-Many Dimension
Advanced Design
Chapter 8 Working with Account Intelligence
Designing a Financial Analysis Cube
Working with Account Intelligence
Creating an Account Dimension
Chapter 9 Currency Conversion and Multiple Languages
Supporting Foreign Currency Conversion
Supporting Foreign Language Translation
Chapter 10 Interacting with a Cube
Implementing Actions
Using Writeback to Modify Analysis Services Data
Chapter 11 Retrieving Data from Analysis Services
Creating Perspectives
Creating MDX Queries
Accessing Analysis Services Using Excel 2007
Creating Reporting Services Reports
Chapter 12 Implementing Security
Understanding Roles
Securing Administrative Access
Securing Data Access
Chapter 13 Designing Aggregations
Understanding Aggregation Design
Using the Aggregation Design Wizard
Using the Usage-Based Optimization Wizard
Production Management
Chapter 14 Managing Partitions and Database Processing
Working with Storage
Managing Analysis Services Processing
Working with Partitions
Chapter 15 Managing Deployment
Deployment Overview
Deployment Mechanics
Deployment Using Business Intelligence Development Studio
Deployment Using the Deployment Wizard
Understanding Deployment Scripts
Migrating Databases and Disaster Recovery
Chapter 16 Advanced Monitoring and Management Tools
Monitoring Analysis Services Using Windows Reliability And Performance Monitor
Monitoring Analysis Services Using SQL Server Profiler
Analysis Services Dynamic Management Views
Appendix About the Author
Contributing Authors
Title:
Microsoft® SQL Server® 2008 Analysis Services Step by Step
Scott Cameron, a Senior Business Intelligence (BI) Architect at Hitachi Consulting, has been developing business intelligence solutions for nine years and has more than 20 years of data analysis experience. He has been working with SQL Server business intelligence components for more than five years, and has taught SQL Server business intelligence courses in the United States and Europe. He has helped several large companies perform their initial implementation of Analysis Services and helped several independent software vendors integrate Analysis Services into their products.
