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
鄂公网安备 42010302001612号 