什么是 Analysis Services?What is Analysis Services?

适用于:yesSQL Server Analysis ServicesyesAzure Analysis ServicesAPPLIES TO:yesSQL Server Analysis ServicesyesAzure Analysis ServicesAnalysis Services 是决策支持和业务分析,Reporting Services 报表,为业务报告和客户端应用程序,例如 Power BI 中,Excel 中,提供的分析数据和其他数据可视化工具中使用的分析数据引擎。 Analysis Services is an analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

典型的工作流包括创作多维或表格数据模型中,将模型作为在本地 SQL Server Analysis Services 或 Azure Analysis Services 服务器实例的数据库部署、 设置重复的数据处理和分配若要允许最终用户通过数据访问的权限。A typical workflow includes authoring a multidimensional or tabular data model, deploying the model as a database to an on-premises SQL Server Analysis Services or Azure Analysis Services server instance, setting up recurring data processing, and assigning permissions to allow data access by end-users. 准备就绪时,可以通过任何支持作为数据源的 Analysis Services 的客户端应用程序访问你的语义的数据模型。When it's ready to go, your semantic data model can be accessed by any client application supporting Analysis Services as a data source.

本地和云中的 Analysis ServicesAnalysis Services on-premises and in the cloud

Analysis Services 现已作为一项 Azure 服务在云中推出。Analysis Services is now available in the cloud as an Azure service. Azure Analysis Services 支持 1200年或更高的兼容性级别的表格模型。Azure Analysis Services supports tabular models at the 1200 and higher compatibility levels. 可支持 DirectQuery、分区、行级安全性、双向关系和翻译。DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported. 若要了解详细信息并免费试用,请参阅 Azure Analysis ServicesTo learn more and give it a try for free, see Azure Analysis Services.

服务器模式Server mode

在安装 Analysis Services 使用 SQL Server 安装程序时,在配置期间指定为该实例的服务器模式。When installing Analysis Services by using SQL Server Setup, during configuration you specify a server mode for that instance. 每种模式都包含特定 Analysis Services 解决方案所独有的不同功能。Each mode includes different features unique to a particular Analysis Services solution.

  • 表格模式下-实现内存中关系数据建模构造 (模型、 表、 列、 度量值、 层次结构)。Tabular Mode - Implement in-memory relational data modeling constructs (model, tables, columns, measures, hierarchies).

  • 多维和数据挖掘模式 - 实现 OLAP 建模构造(多维数据集、维度、度量值)。Multidimensional and Data Mining Mode - Implement OLAP modeling constructs (cubes, dimensions, measures).

  • Power Pivot 模式下-SharePoint 中的实现 Power Pivot 和 Excel 数据模型 (Power Pivot for SharePoint 是一个中间层数据引擎,加载、 查询和刷新在 SharePoint 中托管的数据模型)。Power Pivot Mode - Implement Power Pivot and Excel data models in SharePoint (Power Pivot for SharePoint is a middle-tier data engine that loads, queries, and refreshes data models hosted in SharePoint).

    单个实例只能使用一种模式进行配置,并且以后无法更改。A single instance can be configured with only one mode, and cannot be changed later. 可以在同一服务器上安装具有不同模式的多个实例,但是需要运行安装程序并为每个实例指定配置设置。You can install multiple instances with different modes on the same server, but you'll need to run Setup and specify configuration settings for each instance. 有关详细的信息和在每种模式中提供的不同功能的比较,请参阅比较表格和多维解决方案For detailed information and a comparison of different features offered in each of the modes, see Comparing Tabular and Multidimensional Solutions.

创作和管理解决方案Authoring and managing solutions

若要创建模型,并将其部署到服务器,你可以使用 SQL Server Data Tools,选择是表格或多维和数据挖掘项目模板。To create a model and deploy it to a server, you use SQL Server Data Tools, choosing either a Tabular or Multidimensional and Data Mining project template. 项目模板包含在模型中所需的所有对象的文件夹。The project template contains folders for all of the objects needed in a model. 向导和设计器可帮助你创建许多例如连接到数据源、 关系、 度量值和角色的基本元素。Wizards and designers help you create many of the basic elements such as connecting to data sources, relationships, measures, and roles. 一旦你的模型数据库部署到服务器中,使用 SQL Server Management Studio (SSMS) 来配置数据处理、 监视和管理服务器和数据库。Once your model database is deployed to a server, you use SQL Server Management Studio (SSMS) to configure data processing, monitor, and manage your server and databases. 若要了解详细信息,请参阅工具和 Analysis Services 中使用的应用程序To learn more, see Tools and applications used in Analysis Services.

文档(按区域)Documentation by area

在常规 Azure 文档包含了 Azure Analysis Services 的文档。In-general, documentation for Azure Analysis Services is included with Azure documentation. 而且,SQL Server Analysis Services 的文档包含与 SQL 文档。And, documentation for SQL Server Analysis Services is included with SQL documentation. 但是,至少对于表格模型中,如何创建和部署你的项目是无论你使用何种平台大致相同。However, at least for tabular models, how you create and deploy your projects is much the same regardless of what platform you're using.