O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Book Description

This title shows how to build applications that take advantage of the powerful data-analysis services in Microsoft® SQL Server® 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly.

Table of Contents

  1. Copyright
  2. Preface
  3. Acknowledgments
  4. Administration Fundamentals
    1. A Data Analysis Foundation
      1. Understanding Data Warehousing
      2. The Structure of a Data Warehouse
      3. Understanding Analysis Services
      4. Chapter Summary
    2. Analysis Manager from 500 Feet
      1. Previewing Analysis Manager
      2. Preparing to Create a Cube
      3. Designing a Cube by Using the Cube Wizard
      4. Processing and Browsing a Cube
      5. Chapter Summary
    3. Dimension and Cube Editors
      1. Start the Lesson
      2. Working with a Standard Star Schema Dimension
      3. Working with a Standard Snowflake Dimension
      4. Working with Time Dimensions
      5. Working with a Cube
      6. Working with Measures in a Cube
      7. Specify the Aggregation Function for a Measure
      8. Working with a Parent-Child Dimension
      9. Chapter Summary
    4. Advanced Dimensions and Cubes
      1. Start the Lesson
      2. Creating a Finance Cube
      3. Creating an Internet Tracking Cube
      4. Creating a Forecast Cube
      5. Creating Virtual Cubes
      6. Chapter Summary
    5. Office 2000 Analysis Components
      1. Start the Lesson
      2. Creating an Excel PivotTable Report
      3. Creating an Office PivotTable List
      4. Creating a Local Cube
      5. Chapter Summary
  5. Multidimensional Expressions
    1. MDX Values
      1. Start the Lesson
      2. Creating Simple MDX Expressions
      3. Retrieving Values from Cells
      4. Calculating Relative Contribution
      5. Comparing Values over Time
      6. Chapter Summary
    2. MDX Sets
      1. Start the Lesson
      2. Preparing to Create MDX Queries
      3. Creating Basic MDX Queries
      4. Creating Calculations by Using Aggregation Functions
      5. Chapter Summary
  6. Advanced Administration
    1. Storage Optimization
      1. Start the Lesson
      2. Specifying Options for Optimizing Storage
      3. Managing the Pool of Potential Aggregations
      4. Chapter Summary
    2. Processing Optimization
      1. Start the Lesson
      2. Understanding OLAP Processing
      3. Managing OLAP Processing
      4. Working with Partitions
      5. Automating the Processing of a Database
      6. Chapter Summary
    3. Dimension Optimization
      1. Start the Lesson
      2. Optimizing Dimensions in a Cube
      3. Creating Virtual Dimensions
      4. Chapter Summary
    4. Security
      1. Start the Lesson
      2. Creating Security Roles
      3. Applying Security to a Dimension
      4. Applying Cell-level Security to a Cube
      5. Chapter Summary
    5. About the Authors
  7. Index