SQLServer2000分析服务2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载

SQLServer2000分析服务PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Introduction1

Chapter1 What s New In Analysis Services5

Cube Enhancements6

Dimension Enhancements8

Data Mining Enhancements10

Security Enhancements11

Client Connectivity Enhancements in PivotTable Service12

Other Enhancements12

Chapter2 Installing Analysis Services15

Hardware and Software Requirements for Installing Analysis Services16

Running Setup17

Setup Parameters and Silent Installation19

Reinstalling Analysis Services20

Upgrading from an Earlier Version21

Stopping or Removing Analysis Services21

Backward Compatibility22

7.0Analysis Services Client and Local Cube Support23

Supported Migration Paths for Analysis Services Repositories25

Archiving and Restoring Databases Between Versions of Analysis Services26

Chapter3 Analysis Services Architecture27

Analysis Services Features27

Ease of Use28

Flexible Data Model31

Scalability34

Integration36

Widely Supported APIs and Open Architecture38

Server Architecture39

Server and Client Architecture39

Client Architecture40

Object Architecture42

Object Architecture Overview43

Analysis Server44

Databases46

Data Sources46

Dimensions48

Levels and Members76

Measures87

Cells101

Cubes115

Partitions136

Aggregations148

Roles150

Commands154

Member Properties159

Data Mining Models164

Data Mining Columns176

Security and Authentication186

Administratior Security187

End-User Security188

Operational Considerations229

Chapter4 Data Warehousing and OLAP233

About Data Warehouses234

OLAP and Data Warehouses235

About OLAP235

Maintaining OLAP Data237

Chapter5 Administering Analysis Services241

Before Administering Analysis Services241

Administrative Tools242

Analysis Manager242

Using Active Directory with Analysis Services248

Using Data Transformation Services with Analysis Services249

Using MDX with Analysis Services249

Msmdarch Command250

Administrative Tasks250

Configuring Analysis Servers252

Creating Prerequisite Objests for Cubes254

Building and Processing Cubes261

Creating Security Roles279

Managing Partitions282

Enhancing Dimensions with Optional Features289

Enhancing Cubes with Optional Features296

Updating Cubes and Dimensions315

Building and Using Data Mining Models318

Archiving,Restoring,and Copying Data328

Analyzing and Optimizing Performance333

Automating and Scheduling Administrative Tasks352

Chapter6 Administrator s Reference361

Specifications and Limits361

SQL364

OLE DB Compliance368

OLE DB for Data Mining Compliance372

Chapter7 Multidimensionai Expressions(MDX)377

MDX Overview378

Introduction to MDX378

Key Concepts in MDX379

Comparison of SQL and MDx383

Basic MDX384

The Basic MDX Query385

Members,Tuples,and Sets387

Axis and Slicer Dimensions393

Establishing Cube Context396

Advanced MDX397

Creating and Using Property Values398

Building Named Sets in MDX415

Building Calculated Members in MDX418

Building Caches in MDX426

Building Calculated Cells in MDX428

Creating and Using User-Defined Functions in MDX431

Using Writebacks434

Using DRILLTHROUGH to Retrieve Source Data436

Understanding Pass Order and Solve Order437

Effective MDX448

Comments in MDX448

Working with Empty Cells449

Creating a Cell Within the Context of a Cube454

Working with the RollupChildren Function455

WHERE Clause Overrides457

MDX Functions in Analysis Services458

MDX Function Reference458

Registered Function Libraries551

User-Defined Functions with MDX Syntax554

Chapter8 How To Perform Common Analysis Services Tasks557

Configuring Analysis Servers557

How to register an Analysis server557

How to add a linked Analysis server using SQL Server Enterprise Manager558

How to start the Migrate Repository Wizard559

How to configure Analysis Services for the Web559

How to create a database560

Creating Cubes Prerequisite Objects560

How to specify a data source561

How to create a shared dimension using the Dimension Wizard561

How to create a shared dimension using Dimension Editor562

How to browse a shared dimension563

How to browse a private dimension563

How to create a virtual dimension based on member properties563

How to create a virtual dimension based on columns564

Building and Processing Cubes566

How to start the Cube Wizard567

How to build a cube with Cube Editor567

How to create a private dimension568

How to start the Virtual Cube Wizard569

How to start the Storage Design Wizard569

How to add a multiple-column measure to a cube569

How to process a cube570

How to process a virtual cube570

How to view an SQL statement571

How to change the temporary file folder used by Analysis Services571

How to browse sample data in Cube Editor571

Creating Security Roles572

How to create a database role572

How to create a cube role,change its default values, and specify cell security574

How to create a mining model role and change its default values578

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

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

Managing Cube Storage584

How to create a custom rule for cell security584

How to start the Partition Wizard585

How to process a partition585

How to merge two partitions585

How to specify a data source for a linked cube586

How to create a linked cube586

How to process a linked cube587

Enhancing Dimensions587

How to create a member property in a shared dimension588

How to create a custom rollup operator for a shared dimension588

How to create a custom rollup operator for a private dimension589

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

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

How to create member groups592

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

How to create a dimension with multiple hierarchies in Dimension Editor595

How to add a hierarchy to an existing dimension596

Enhancing Cubes with Optional Features597

How to create calculated cells598

How to import calculated cells into a virtual cube599

How to edit a calculated cells definition599

How to rename a calculated member600

How to create a calculated member in a regular cube600

How to import a calculated member into a virtual cube602

How to edit a calculated member in a virtual cube602

How to create a calculated member in a virtual cube603

How to create a named set in a regular cube604

How to edit a named set in a virtual cube605

How to import a named set into a virtual cube605

How to create a named set in a virtual cube606

How to create an action in a regular cube606

How to import an action into a virtual cube607

How to edit an action in a virtual cube607

How to create an action in virtual cube608

How to test an action608

How to write-enable a cube609

How to browse writeback data for a cube610

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

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

How to specify drillthrough options for a regular cube611

How to specify drillthrough options for a virtual cube612

How to specify drillthrough options for a linked cube613

How to specify drillthrough options for a partition615

Updating Cubes and Dimensions616

How to incrementally update a cube616

How to refresh data in a cube618

How to incrementally update a sharde dimension618

How to rebuild the structure of a shared dimension618

Managing Data Mining Models619

How to start the Mining Model Wizard619

How to start Relational Mining Model Editor620

How to start OLAP Mining Model Editor620

How to process a data mining model620

How to add a role to a data mining model621

How to start Mining Model Role Managerk621

Archiving, Restoring,and Copying Data622

How to archive an Analysis Services database using Analysis Manager622

How to archive an Analysis Services database using the msmdarch command623

How to restore an Analysis Services database using Analysis Manager624

How to restore an Analysis Services database using the msmdarch command625

How to copy and paste an object626

Analyzing and Optimizing Performance627

How to start the Usage Analysis Wizard627

How to start the Usage-Based Optimization Wizard627

Automating and Scheduling Administrative Tasks627

How to create an Analysis Services Processing task628

How to create a Relational Data Mining Prediction Query task629

Index Topics in the SQL Server2000 Reference Library631