本書包含了SQL Server 2000分析服務(wù)的提綱和詳細(xì)內(nèi)容。包括SQL Server 2000分析服務(wù)新增內(nèi)容，以及如何安裝這些服務(wù)。論述了SQL Server 2000分析服務(wù)結(jié)構(gòu)、數(shù)據(jù)倉(cāng)庫(kù)、數(shù)據(jù)采集和OLAP的詳細(xì)內(nèi)容。為您提供了如何管理分析服務(wù)、MXD和相關(guān)決策工具的全面信息。本書由微軟公司專家編寫，實(shí)用性強(qiáng)，是系統(tǒng)管理員和程序開發(fā)人員的必備參考書。
作者簡(jiǎn)介
暫缺《SQL Server 2000分析服務(wù)（影印版）》作者簡(jiǎn)介
圖書目錄
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
鄂公網(wǎng)安備 42010302001612號(hào) 