SQL Server 2000分析服务（影印版）

Introductin

Chapter 1 What’s New In Analysis Services

Cube Enhancements

Dimension Enhancements

Data Mining Enhancements

Security Enhancements

Client Connectivity Enhancements in PivotTable Service

Other Enhancements

Chapter 2 Installing Analysis Services

Hardware and Software Requirements for Installing Analysis Services

Running Setup

Setup Parameters and Silent Installation

Reinstalling Analysis Services

Stopping or Removing Analysis Services

Upgrading from an Earlier Version

Backward Compatibility

7.0 Analysis Services Client and Local Cube Support

Supported Migration Paths for Analysis Services Repositories

Archiving and Restoring Databases Between Versions of Analysis Services

Chapter 3 Analysis Services Architecture

Analysis Services Features

Ease of Use

Flexible Data Model

Scalability

Integration

Widely Supported APIs and Open Architecture

Server and Client Architecture

Server Architecture

Client Architecture

Object Architecture

Object Architecture Overview

Analysis Server

Databases

Data Sources

Dimentsions

Levels and Members

Measures

Cells

Cubes

Partitons

Aggregations

Roles

Commands

Member Properties

Data Mining Models

Data Mining Columns

Security and Authentication

Administrator Security

End-User Security

Operational Considerations

Chapter4 Data Warehousing and OLAP

About Data Warehouses

About OLAP

OLAP and Data Warehouses

Maintaining OLAP Data

Chapter5 Administering Analysis Services

Before Administering Analysis Services

Administrative Tools

Analysis Manager

Using Active Directoty with Analysis Services

Using Data Transformation Services with Analysis Services

Using MDX with Analysis Services

Msmdarch Command

Administrative Tasks

Configuring Analysis Servers

Creating Prerequisite Objects for Cubes

Building and Processing Cubes

Creating Security Roles

Mannging Partitions

Eanaging Dimensions with Optional Features

Enhancing Cubes with Optional Features

Updating Cubes and Dimensions

Building and Using Data Mining Models

Archiving，Restoring，andCopying Data

Analyzing and Optimizing Perfomance

Automating and Scheduling Administrative Tasks

Chapter6 Administrator’s Reference

Specifications and Limits

SQL

OLE DB Compliance

OLE DB for Data Mining Compliance

Chapter7 Multidimensional Expressions（MDX）

MDX Overview

Introduction to MDX

Key Concepts in MDX

Comparison of SQL and MDX

Basic MDX

The Basic MDX Query

Members，Tuples，and Sets

Axis and Slicer Dimensions

Establishing Cube Context

Advanced MDX

Creating and Using Property Values

Building Named Sets in MDX

Building Calculated Members in MDX

Building Caches in MDX

Building Calculated Cells in MDX

Creating and Using User-Defined Functions inMDX

Using Writebacks

Using DRILLTHROUGH to Retrieve Source Data

Understanding Pass Order Solve Order

Effective MDX

Comments in MDX

Working with Empty Cells

Creating a Cell Within the Context of a Cube

Working with the Rollup Childern Function

WHERE Clause Overrides

MDX Function in Analysis Services

MDX Functions Reference

Registered Function Libraries

User-Defined Functions with MDX Syntax

Chapter 8 How To Perform Common Analysis Services Tasks

Configuring Ayalysis Servers

How to register an Analysis server

How to add a linked Ayalysis server using SQL Server Enterprise Manager

How to start the Migrate Repository Wizard

How to configure Ayalysis Services for the Web

Creating Cubes’Prerequisite Objects

How to create a database

How to specify a data source

How to create a shared dimension using the Dimension Wizard

How to create a shared dimension using dimension Editor

How to browse a shared dimension

How to browse a private dimension

How to create a virtual dimension based on member properties

How to create a virtual dimension based on columns

Building and Processing Cubes

How to start the Cube Wizard

How to buile a cube with Cube Editor

How to create a private dimension

How to add a multilpe-column measure to a cube

How to start the Virtual Cube Wizard

How to start the Storage Design Wizard

How to process a cube

How to process a virtual cube

How to view an SQL statement

How to change the temporary file folder used by Analysis Services

How to browse sample data in Cube Editor

Creating Security Roles

How to create a database role

How to create a cube role，change its default values，and specify cell security

How to create mining model role and change its default values

How to create a custom rule for dimension security in a database role

How to create a custom rule for dimension security in a cube role

How to create a custom rule for cell security

Managing Cube Storage

How to start the Partition Wizard

How to process a partition

How to merge two partitons

How to specify a data source for a linked cube

How to create a linked cube

How to process a linked cube

Enhancing Dimensions

How to create a member property in a shared dimension

How to create a custom rollup operator for a shared dimension

How to create a custom rollup operator for a private dimension

How to create or select a column to store custom member formulas

How to create a custom member formula in a write-enabled dimension

How to create member groups

How to create a dimension with multiple hierarchies in the Dimension Wizard

How to create a dimension with multiple hierarchies in Dimension Editor

How to add a hierarchy to an existing dimension

Enhancing Cubes with Optional Features

How to create calculated cells

How to import calculated cells into a virtual cube

How to edit a calculated cells definition

How to rename a calculated member

How to create a calculated member in a regular cube

How to import a calculated member into a virtual cube

How to edit a calculated member in a virtual cube

How to create a calculated member in a virtual cube

How to create a named set in a regrlar cube

How to import a named set into a virtual cube

How to edit a named set in a virtual cube

How to create a named set in a virtual cube

How to create an action in a regular cube

How to import an action into a virtual cube

How to edit an action in a virtual cube

How to create an action in a virtual cube

How to test an action

How to browse writeback data for a cube

How to delete writeback data for a cube and write-disable it

How to convert a cube’s writeback data to a partition and write-disable the cube

How to specify drillthrough options for a regular cube

How to specify drillthrough options for a virtual cube

How to specify drillthrough options for a linked cube

How to specify drillthrough options for a partition

Updating Cubes and Dimensions

How to incrementally update a cube

How to refresh data in a cube

How to incrementally update a shared dimension

How to rebuild the structure of a shared dimension

Managing Data Mining Models

How to start the Miniing Model Wizard

How to start Relational Mining Model Editor

How to start OLAP Mining Model Editor

How to process a data mining model

How to start Mining Model Role Manager

How to add a role to a data mining model

Archiving，restoring，and Copring Data

How to archive an Analysis Services database using Analysis Manager

How to archive an Analysis Services database using the msmdarch command

How to restore an Analysis Services database using Analysis Manager

How to restore an Analysis Services database using the msmdarch command

How to copy and paste an object

Analyzing and Optimizing performance

How to start the Usage Analysis Wizard

How to start the Usage-Based Optimixation Wizard

Automating and Scheduling Administrative Tasks

How to create an Analysis Services Processing task

How to create a Relational Data Mining Prediction Query task

Index Topics in the SQL Server 2000 Reference Library