Microsoft SQL Server 2008 Analysis Services 实战指南

需积分: 10 57 浏览量更新于2024-07-29 收藏 16.18MB PDF 举报

"Microsoft.Press.Microsoft.SQL.Server.2008.Analysis.Services.Step.by.Step" 是一本专注于Microsoft SQL Server 2008 Analysis Services的详细指南，由Hitachi Consulting出版，并由Microsoft Press发行。这本书旨在帮助读者逐步掌握如何设计、实施和管理SQL Server 2008的Analysis Services。 SQL Analysis Service是Microsoft SQL Server中的一个关键组件，专门用于商业智能（BI）和数据仓库解决方案。它提供了多维数据处理和在线分析处理（OLAP）功能，使得用户能够对大量数据进行快速查询和复杂的分析。在本书中，读者将学习到以下核心知识点： 1. **Analysis Services基础**：涵盖Analysis Services的基本概念，包括数据挖掘、多维数据集、立方体和KPIs（关键性能指标），以及它们在BI解决方案中的作用。 2. **项目设置与模型设计**：详细解释如何创建和配置Analysis Services项目，包括数据源的连接、数据源视图的构建以及多维模型的设计。 3. **维度建模**：深入讨论如何设计和实现维度，包括层次结构、键属性、名称列和成员属性，以及如何优化维度以提高查询性能。 4. **度量值组和计算**：介绍如何定义度量值组，创建计算成员和公式，以支持业务报表和分析需求。 5. **处理和部署**：解释如何对多维模型进行处理，确保数据的准确性和可用性，以及如何部署和更新Analysis Services实例。 6. **安全与权限**：讨论如何设置角色和权限，以控制用户访问Analysis Services对象和数据。 7. **数据挖掘**：介绍SQL Server 2008的数据挖掘功能，包括模型创建、训练、验证和使用，以及与Analysis Services的集成。 8. **性能调优**：提供关于监控和优化Analysis Services性能的策略，包括查询优化、内存管理和硬件配置建议。 9. **共享数据源和报告集成**：讲解如何使用Analysis Services与Excel、PerformancePoint和SharePoint等工具集成，创建交互式报表和仪表板。 10. **故障排查与维护**：分享了如何识别和解决Analysis Services遇到的问题，以及日常维护的最佳实践。通过这本步骤式的指南，读者不仅可以了解SQL Server 2008 Analysis Services的核心功能，还能获得实际操作经验，从而在自己的项目中有效应用这些技术。无论是初学者还是经验丰富的DBA或BI开发者，都能从这本书中获益匪浅。

xvi Introduction

Detailed requirements for installing SQL Server 2008 can be found in the SQL Server

Books Online article “Hardware and Software Requirements for Installing SQL Server 2008”

(http://msdn.microsoft.com/en-us/library/ms143506.aspx).

The step-by-step exercises in this book and the accompanying practice ﬁles were tested

using Windows Vista Enterprise Service Pack 1 and Microsoft SQL Server 2008 Developer

Edition. If you’re using another version of the operating system or SQL Server 2008, you

might notice some slight differences.

Practice Files and SQL Server 2008 Conﬁguration

The companion CD inside this book contains the practice ﬁles that you’ll use as you perform

the exercises. The practice ﬁles and the step-by-step instructions in the lessons let you learn

by doing, which is an easy and effective way to acquire and remember new skills. The com-

panion CD also contains a SQL Server 2008 database that is the data source for the analytical

solutions that you will create and use throughout this book.

Installing the Practice Files

Follow these steps to install the practice ﬁles on your computer so that you can use them

with the exercises.

1. Remove the companion CD from the package inside this book and insert it into your

CD-ROM drive.

Note

An end user license agreement should open automatically. If this agreement does

not appear, open Computer on the desktop or Start menu, double-click the icon for your

CD-ROM drive, and then double-click StartCD.exe.

2. Review the end user license agreement. If you accept the terms, select the accept op-

tion and then click Next.

A menu will appear with options related to the book.

3. Click Install Practice ﬁles.

4. Follow the instructions that appear.

The practice ﬁles will be copied from the CD to your hard drive. The default installation

folder is C:\Microsoft Press\Analysis Services 2008 SBS. If you install the practice ﬁles in

a different location, you’ll need to reference the new location when working through

the exercises. Each chapter in this book explains when and how to use any practice ﬁles

for that chapter. When it’s time to use a practice ﬁle, the book will list the instructions

for how to open the ﬁle.

Introduction xvii

Tip In the C:\Microsoft Press\Analysis Services 2008 SBS\Answers folder, you’ll ﬁnd a sep-

arate folder for each chapter in which you make changes to the practice ﬁles. The ﬁles in

these folders are copies of these sample ﬁles when you complete a chapter. You can refer

to these ﬁles if you want to preview the results of completing all exercises in a chapter.

5. Remove the CD from your CD-ROM drive.

Conﬁguring SQL Server 2008

The exercises in this book will have you create an Analysis Services database and populate

that database using data contained in a SQL Server database. The exercises assume that SQL

Server 2008 is installed on your computer. The following steps will guide you through the

process of conﬁguring SQL Server and Analysis Services so that you can complete the exer-

cises. To complete these steps you must ﬁrst install the practice ﬁles; you will also need to be

a member of the Administrators group on your computer.

Analysis Services will need to connect to SQL Server, so you must ﬁrst discover the Windows

1. On the Microsoft Windows task bar, click Start. In the Search box, type services and

then in the Programs group select Services. If a User Account Control dialog box

appears, click Continue. (If you are using Windows XP or Windows Server 2003, click

Start, select Control Panel, select Administrative Tools, and then select Services.)

2. In the Services window, ﬁnd SQL Server Analysis Services in the Name column and

make a note of the value in the Log On As column.

Important

The Analysis Services login user name will be a two-part name with the for-

mat DomainName\Username or .\Username or it may be Network Service or Local Service.

You will use this user name in step 5.

3. Close the Services window.

4. On the Microsoft Windows task bar, click the Start button and then click Computer.

In Windows Explorer, browse to C:\Microsoft Press\Analysis Services 2008 SBS\Setup.

Right-click SSAS_Login.sql and select Open. In the Connect To Database Engine dialog

box, click Cancel.

Microsoft SQL Server Management Studio opens and displays the SSAS_Login.sql ﬁle in

edit mode. This SQL script ﬁle creates a SQL Server login for Analysis Services (unless it

already exists) and then grants permissions to that login. You will need to edit the script

and enter the Analysis Services login user name that you discovered in step 2.

xviii Introduction

5. In the second line of the ﬁle, ﬁnd DOMAIN\ACCOUNT and replace it with the two-part

name you discovered in step 2.

Important

If in step 2 you discovered that the Analysis Services login user name is

Network Service or Local Service, then you will need to replace DOMAIN\ACCOUNT with

NT Authority\Network Service or NT Authority\Local Service.

If the user name you discovered in step 2 has the format DomainName\Username, use

that two-part name. If the user name you discovered has the format .\UserName, you

will need to replace the dot (.) with the name of the local computer. For example, on

my computer the Analysis Services login is .\AS_Service. The name of my computer

is Hitachi, so I will need to ﬁnd DOMAIN\ACCOUNT and replace it with Hitachi\AS_

Service. For me, the second line of the script should looks like this:

SET @user ='Hitachi\AS_Service';

6. On the File menu, select Exit. In the dialog box, click Yes to save the changes to SSAS_

7. In Windows Explorer, right-click Setup.cmd and select Open.

This command ﬁle attaches the Microsoft SQL Server 2008 database that is the data

source for the analytical solution you will create and use throughout this book. It then

executes the script that you modiﬁed in step 5.

Now you’re set to begin working through the exercises.

Uninstalling the Practice ﬁles

Follow these steps to remove the practice ﬁles from your computer.

1. In Control Panel, open Add Or Remove Programs.

2. From the list of Currently Installed Programs, select Microsoft SQL Server 2008 Analysis

Services Step by Step.

3. Click Remove.

4. Follow the instructions that appear to remove the practice ﬁles.

Find Additional Content Online

As new or updated material becomes available that complements your book, it will be

posted online on the Microsoft Press Online Developer Tools Web site. The type of material

you might ﬁnd includes updates to book content, articles, links to companion content, errata,

sample chapters, and more. This Web site is available at www.microsoft.com/learning/books

/online/developer, and is updated periodically.

剩余423页未读，继续阅读

「已注销」

粉丝: 1
资源: 4

Microsoft SQL Server 2008 Analysis Services 实战指南

Microsoft.Press.Inside.Microsoft.SQL.Server.2008.T-SQL.Programming

Microsoft.Press.Microsoft.SQL.Server.2005.Applied.Techniques.Step.by.Step.z01

Microsoft.Press.Microsoft.SQL.Server.2008.MDX.Step.by.Step.Feb.2009.rar

Microsoft.Press.Microsoft.SQL.Server.2005.Applied.Techniques.Step.by.Step.z06

Microsoft.Press.Microsoft.SQL.Server.2005.Applied.Techniques.Step.by.Step.z05

Microsoft.Press.Microsoft.SQL.Server.2005.Applied.Techniques.Step.by.Step.z04

MS Press SQL Server 05 Database Essentials Step by Step.rar

深入学习Microsoft SQL Server 2008 Analysis Services

Microsoft SQL Server 2008 Analysis Services详解教程

步步指南：2008年Microsoft SQL Server Analysis Services实战教程

最新资源