多维建模(Adventure Works 教程)Multidimensional Modeling (Adventure Works Tutorial)

适用对象:是SQL Server Analysis Services 否Azure Analysis Services 否Power BI PremiumAPPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services noPower BI Premium

欢迎使用 Analysis ServicesAnalysis Services 教程。Welcome to the Analysis ServicesAnalysis Services Tutorial. 本教程通过在所有示例中使用虚构公司 SQL Server Data ToolsSQL Server Data Tools ,说明如何使用 Analysis ServicesAnalysis Services 开发和部署 Adventure Works CyclesAdventure Works Cycles 项目。This tutorial describes how to use SQL Server Data ToolsSQL Server Data Tools to develop and deploy an Analysis ServicesAnalysis Services project, using the fictitious company Adventure Works CyclesAdventure Works Cycles for all examples.

学习内容What you learn

在本教程中,您将了解以下内容:In this tutorial, you will learn the following:

  • 如何在 Analysis ServicesAnalysis ServicesSQL Server Data ToolsSQL Server Data Tools项目中定义数据源、数据源视图、维度、属性、属性关系、层次结构和多维数据集。How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis ServicesAnalysis Services project within SQL Server Data ToolsSQL Server Data Tools.

  • 如何通过将 Analysis ServicesAnalysis Services 项目部署到 Analysis ServicesAnalysis Services实例来查看多维数据集和维度数据,以及如何在随后处理已部署的对象以使用基础数据源中的数据来填充对象。How to view cube and dimension data by deploying the Analysis ServicesAnalysis Services project to an instance of Analysis ServicesAnalysis Services, and how to then process the deployed objects to populate them with data from the underlying data source.

  • 如何在 Analysis ServicesAnalysis Services 项目中修改度量值、维度、层次结构、属性和度量值组,以及如何将增量更改部署到开发服务器上的已部署多维数据集。How to modify the measures, dimensions, hierarchies, attributes, and measure groups in the Analysis ServicesAnalysis Services project, and how to then deploy the incremental changes to the deployed cube on the development server.

  • 如何定义多维数据集内的计算、关键绩效指标 (KPI)、操作、透视、翻译和安全角色。How to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.

在此教程中随附应用场景说明,以便您可以更好地理解这些课程的上下文。A scenario description accompanies this tutorial so that you can better understand the context for these lessons. 有关详细信息,请参阅 Analysis Services 教程方案For more information, see Analysis Services Tutorial Scenario.

必要條件Prerequisites

要完成本教程的所有课程,您将需要示例数据、示例项目文件以及软件。You will need sample data, sample project files, and software to complete all of the lessons in this tutorial. 有关如何查找和安装本教程的必备组件的说明,请参阅 安装 Analysis Services 多维建模教程的示例数据和项目For instructions on how to find and install the prerequisites for this tutorial, see Install Sample Data and Projects for the Analysis Services Multidimensional Modeling Tutorial.

此外,必须具有下列权限才能成功完成本教程:Additionally, the following permissions must be in place to successfully complete this tutorial:

  • 您必须是 Analysis ServicesAnalysis Services 计算机上本地管理员组的成员或 Analysis ServicesAnalysis Services实例中的服务器管理角色的成员。You must be a member of the Administrators local group on the Analysis ServicesAnalysis Services computer or be a member of the server administration role in the instance of Analysis ServicesAnalysis Services.

  • 您必须具有读取权限AdventureWorksDW示例数据库。You must have Read permissions in the AdventureWorksDW sample database. 此示例数据库对于 SQL Server 2017SQL Server 2017 版本有效。This sample database is valid for the SQL Server 2017SQL Server 2017 release.

课程Lessons

本教程包括以下几课。This tutorial includes the following lessons.

课程Lesson 学完本课的估计时间Estimated time to complete
第 1 课:定义数据源视图中 Analysis Services 项目Lesson 1: Defining a Data Source View within an Analysis Services Project 15 分钟15 minutes
第 2 课:定义和部署多维数据集Lesson 2: Defining and Deploying a Cube 30 分钟30 minutes
第 3 课:修改度量值、 属性和层次结构Lesson 3: Modifying Measures, Attributes and Hierarchies 45 分钟45 minutes
第 4 课:定义高级的属性和维度属性Lesson 4: Defining Advanced Attribute and Dimension Properties 120 分钟120 minutes
第 5 课:定义维度和度量值组之间的关系Lesson 5: Defining Relationships Between Dimensions and Measure Groups 45 分钟45 minutes
第 6 课:定义计算Lesson 6: Defining Calculations 45 分钟45 minutes
第 7 课:定义关键绩效指标(Kpi)Lesson 7: Defining Key Performance Indicators (KPIs) 30 分钟30 minutes
第 8 课:定义操作Lesson 8: Defining Actions 30 分钟30 minutes
第 9 课:定义透视和翻译Lesson 9: Defining Perspectives and Translations 30 分钟30 minutes
第 10 课:定义管理角色Lesson 10: Defining Administrative Roles 15 分钟15 minutes

备注

将在本教程中创建的多维数据集数据库是一个简化的版的Analysis ServicesAnalysis Services多维模型项目是 GitHub 上的下载可用的 Adventure Works 示例数据库的一部分。The cube database that you will create in this tutorial is a simplified version of the Analysis ServicesAnalysis Services multidimensional model project that is part of the Adventure Works sample databases available for download on GitHub. 对 Adventure Works 多维数据库的教程版本进行了简化,以便重点关注您将要立即掌握的特定技能。The tutorial version of the Adventure Works multidimensional database is simplified to bring greater focus to the specific skills that you will want to master right away. 在完成该教程后,请考虑自己探索该多维模型项目,以便进一步理解 Analysis ServicesAnalysis Services 多维建模。After you complete the tutorial, consider exploring the multidimensional model project on your own to further your understanding of Analysis ServicesAnalysis Services multidimensional modeling.

下一步Next Step

若要开始本教程,请继续第一课:第 1 课:定义数据源视图中 Analysis Services 项目To begin the tutorial, continue to the first lesson: Lesson 1: Defining a Data Source View within an Analysis Services Project.