SQL Server 2000开发宝库影印丛书——SQL Server 2000分析服务（影印版） (2008 年度畅销榜NO.50804 )

本书包含了SQL Server 2000分析服务的提纲和详细内容。包括SQL Server 2000分析服务新增内容，以及如何安装这些服务。论述了SQL Server 2000分析服务结构、数据仓库、数据采集和OLAP的详细内容。为您提供了如何管理分析服务、MXD和相关决策工具的全面信息。\r\n 本书由微软公司专家编写，实用性强，是系统管理员和程序开发人员的必备参考书。\r\n

Introductin\r\n\r\nChapter 1 What’s New In Analysis Services\r\n\r\nCube Enhancements\r\nDimension Enhancements\r\nData Mining Enhancements\r\nSecurity Enhancements\r\nClient Connectivity Enhancements in PivotTable Service\r\nOther Enhancements\r\n\r\nChapter 2 Installing Analysis Services\r\n\r\nHardware and Software Requirements for Installing Analysis Services\r\nRunning Setup\r\nSetup Parameters and Silent Installation\r\nReinstalling Analysis Services\r\nStopping or Removing Analysis Services\r\nUpgrading from an Earlier Version\r\nBackward Compatibility\r\n7.0 Analysis Services Client and Local Cube Support\r\nSupported Migration Paths for Analysis Services Repositories\r\nArchiving and Restoring Databases Between Versions of Analysis Services\r\n\r\nChapter 3 Analysis Services Architecture\r\n\r\nAnalysis Services Features\r\nEase of Use\r\nFlexible Data Model\r\nScalability\r\nIntegration\r\nWidely Supported APIs and Open Architecture\r\nServer and Client Architecture\r\nServer Architecture\r\nClient Architecture\r\nObject Architecture\r\nObject Architecture Overview\r\nAnalysis Server\r\nDatabases\r\nData Sources\r\nDimentsions\r\nLevels and Members\r\nMeasures\r\nCells\r\nCubes\r\nPartitons\r\nAggregations\r\nRoles\r\nCommands\r\nMember Properties\r\nData Mining Models\r\nData Mining Columns\r\nSecurity and Authentication\r\nAdministrator Security\r\nEnd-User Security\r\nOperational Considerations\r\n\r\nChapter4 Data Warehousing and OLAP\r\nAbout Data Warehouses\r\nAbout OLAP\r\nOLAP and Data Warehouses\r\nMaintaining OLAP Data\r\n\r\nChapter5 Administering Analysis Services\r\nBefore Administering Analysis Services\r\nAdministrative Tools\r\nAnalysis Manager\r\nUsing Active Directoty with Analysis Services\r\nUsing Data Transformation Services with Analysis Services\r\nUsing MDX with Analysis Services\r\nMsmdarch Command\r\nAdministrative Tasks\r\nConfiguring Analysis Servers\r\nCreating Prerequisite Objects for Cubes\r\nBuilding and Processing Cubes\r\nCreating Security Roles\r\nMannging Partitions\r\nEanaging Dimensions with Optional Features\r\nEnhancing Cubes with Optional Features\r\nUpdating Cubes and Dimensions\r\nBuilding and Using Data Mining Models\r\nArchiving，Restoring，andCopying Data\r\nAnalyzing and Optimizing Perfomance\r\nAutomating and Scheduling Administrative Tasks\r\n\r\nChapter6 Administrator’s Reference\r\nSpecifications and Limits\r\nSQL\r\nOLE DB Compliance\r\nOLE DB for Data Mining Compliance\r\n\r\nChapter7 Multidimensional Expressions（MDX）\r\nMDX Overview\r\nIntroduction to MDX\r\nKey Concepts in MDX\r\nComparison of SQL and MDX\r\nBasic MDX\r\nThe Basic MDX Query\r\nMembers，Tuples，and Sets\r\nAxis and Slicer Dimensions\r\nEstablishing Cube Context\r\nAdvanced MDX\r\nCreating and Using Property Values\r\nBuilding Named Sets in MDX\r\nBuilding Calculated Members in MDX\r\nBuilding Caches in MDX\r\nBuilding Calculated Cells in MDX\r\nCreating and Using User-Defined Functions inMDX\r\nUsing Writebacks\r\nUsing DRILLTHROUGH to Retrieve Source Data \r\nUnderstanding Pass Order Solve Order\r\nEffective MDX\r\nComments in MDX\r\nWorking with Empty Cells\r\nCreating a Cell Within the Context of a Cube\r\nWorking with the Rollup Childern Function\r\nWHERE Clause Overrides\r\nMDX Function in Analysis Services\r\nMDX Functions Reference\r\nRegistered Function Libraries\r\nUser-Defined Functions with MDX Syntax\r\n\r\nChapter 8 How To Perform Common Analysis Services Tasks\r\n\r\nConfiguring Ayalysis Servers\r\nHow to register an Analysis server\r\nHow to add a linked Ayalysis server using SQL Server Enterprise Manager\r\nHow to start the Migrate Repository Wizard\r\nHow to configure Ayalysis Services for the Web\r\nCreating Cubes’Prerequisite Objects\r\nHow to create a database\r\nHow to specify a data source\r\nHow to create a shared dimension using the Dimension Wizard\r\nHow to create a shared dimension using dimension Editor\r\nHow to browse a shared dimension\r\nHow to browse a private dimension\r\nHow to create a virtual dimension based on member properties\r\nHow to create a virtual dimension based on columns\r\nBuilding and Processing Cubes\r\nHow to start the Cube Wizard\r\nHow to buile a cube with Cube Editor\r\nHow to create a private dimension\r\nHow to add a multilpe-column measure to a cube \r\nHow to start the Virtual Cube Wizard\r\nHow to start the Storage Design Wizard\r\nHow to process a cube\r\nHow to process a virtual cube\r\nHow to view an SQL statement\r\nHow to change the temporary file folder used by Analysis Services\r\nHow to browse sample data in Cube Editor\r\nCreating Security Roles\r\nHow to create a database role\r\nHow to create a cube role，change its default values，and specify cell security\r\nHow to create mining model role and change its default values\r\nHow to create a custom rule for dimension security in a database role\r\nHow to create a custom rule for dimension security in a cube role\r\nHow to create a custom rule for cell security\r\nManaging Cube Storage\r\nHow to start the Partition Wizard\r\nHow to process a partition\r\nHow to merge two partitons\r\nHow to specify a data source for a linked cube\r\nHow to create a linked cube\r\nHow to process a linked cube\r\nEnhancing Dimensions\r\nHow to create a member property in a shared dimension\r\nHow to create a custom rollup operator for a shared dimension\r\nHow to create a custom rollup operator for a private dimension\r\nHow to create or select a column to store custom member formulas\r\nHow to create a custom member formula in a write-enabled dimension\r\nHow to create member groups\r\nHow to create a dimension with multiple hierarchies in the Dimension Wizard\r\nHow to create a dimension with multiple hierarchies in Dimension Editor\r\nHow to add a hierarchy to an existing dimension\r\nEnhancing Cubes with Optional Features\r\nHow to create calculated cells\r\nHow to import calculated cells into a virtual cube\r\nHow to edit a calculated cells definition\r\nHow to rename a calculated member\r\nHow to create a calculated member in a regular cube\r\nHow to import a calculated member into a virtual cube\r\nHow to edit a calculated member in a virtual cube\r\nHow to create a calculated member in a virtual cube\r\nHow to create a named set in a regrlar cube\r\nHow to import a named set into a virtual cube\r\nHow to edit a named set in a virtual cube\r\nHow to create a named set in a virtual cube\r\nHow to create an action in a regular cube\r\nHow to import an action into a virtual cube\r\nHow to edit an action in a virtual cube\r\nHow to create an action in a virtual cube\r\nHow to test an action\r\nHow to browse writeback data for a cube\r\nHow to delete writeback data for a cube and write-disable it \r\nHow to convert a cube’s writeback data to a partition and write-disable the cube\r\nHow to specify drillthrough options for a regular cube\r\nHow to specify drillthrough options for a virtual cube\r\nHow to specify drillthrough options for a linked cube\r\nHow to specify drillthrough options for a partition \r\nUpdating Cubes and Dimensions\r\nHow to incrementally update a cube\r\nHow to refresh data in a cube\r\nHow to incrementally update a shared dimension\r\nHow to rebuild the structure of a shared dimension\r\nManaging Data Mining Models\r\nHow to start the Miniing Model Wizard\r\nHow to start Relational Mining Model Editor\r\nHow to start OLAP Mining Model Editor\r\nHow to process a data mining model\r\nHow to start Mining Model Role Manager\r\nHow to add a role to a data mining model\r\nArchiving，restoring，and Copring Data\r\nHow to archive an Analysis Services database using Analysis Manager\r\nHow to archive an Analysis Services database using the msmdarch command \r\nHow to restore an Analysis Services database using Analysis Manager\r\nHow to restore an Analysis Services database using the msmdarch command\r\nHow to copy and paste an object\r\nAnalyzing and Optimizing performance\r\nHow to start the Usage Analysis Wizard\r\nHow to start the Usage-Based Optimixation Wizard\r\nAutomating and Scheduling Administrative Tasks\r\nHow to create an Analysis Services Processing task\r\nHow to create a Relational Data Mining Prediction Query task\r\n\r\nIndex Topics in the SQL Server 2000 Reference Library\r\n

无封面