什麼是 Analysis Services?What is Analysis Services?

Analysis Services 是用於決策支援和商業分析,Reporting Services 報表、 報表和用戶端應用程式,例如 Excel、 Power BI 提供的分析資料和其他資料視覺效果工具的分析資料引擎。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

當使用 SQL Server 安裝程式安裝 Analysis Services,在設定期間指定該執行個體的伺服器模式。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 模型化建構 (Cube、維度、量值)。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 Analysis Services 的文件隨附於 Azure 文件。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.