在 SharePoint Server 2013 中規劃 Excel Services 資料模型設定Plan Excel Services Data Model settings in SharePoint Server 2013

摘要:指定要搭配 Excel Services 的互動式資料模型使用的 Analysis Services 執行個體。Summary: Specify an instance of Analysis Services to be used with interactive data models in Excel Services.

在 Excel Services 中,您可以指定一或多個執行個體的 SQL Server 2012 SP1 Analysis Services (SSAS) 以用於處理資料模型建立的 Excel 2016。在此組態中,SQL Server 2012 Analysis Services 提供適用於 Excel Services 的後端服務以負載、 查詢伺服器及重新整理 Excel 2016 資料模型,讓使用者與這些類型的瀏覽器中的活頁簿的互動方式。SQL Server 2012 Analysis Services 必須安裝在 SQL Server PowerPivot for SharePoint 模式。In Excel Services, you can specify one or more instances of SQL Server 2012 SP1 Analysis Services (SSAS) for use in processing Data Models created in Excel 2016. In this configuration, SQL Server 2012 Analysis Services provides a backend service for Excel Services to load, query, and refresh Excel 2016 Data Models so that users can interact with these types of workbooks in the browser. SQL Server 2012 Analysis Services must be installed in SQL Server PowerPivot for SharePoint mode.

資料模型時您選擇多個資料表中相同的匯入作業在 Excel 中自動建立 Excel Services] 中。如果您建立匯入的資料儲存在多個資料表中的活頁簿時,需要的 SQL Server 2012 SP1 Analysis Services (SSAS) 如果您想要在 SharePoint Server 2013 中的資料互動指定 Excel Services 中的執行個體。In Excel Services, Data Models are created automatically when you choose multiple tables in the same import operation in Excel. If you build workbooks that store imported data in multiple tables, you will need an instance of SQL Server 2012 SP1 Analysis Services (SSAS) specified in Excel Services if you want to interact with that data in SharePoint Server 2013.

Analysis Services 必須位於相同網路和網域做為 SharePoint Server 2013 伺服器陣列。安裝及管理使用 SQL Server 安裝媒體和工具。安裝 Analysis Services 之後,只有額外的設定是設定 Excel Services 應用程式設定以指到 Analysis Services 伺服器執行個體。Analysis Services must be on the same network and domain as your SharePoint Server 2013 farm. You install and manage it by using SQL Server installation media and tools. After you install Analysis Services, the only additional configuration is to configure Excel Services Application Settings to point to the Analysis Services server instance.

您可以指定多個 Analysis Services 執行個體中 Excel Services 設定。當您這麼做時,資料模型所進行資料流處理這些功能的負載平衡循環配置資源的執行個體。如果您注意到 Analysis Services 執行個體上的資源使用狀況過多或使用瀏覽器中的資料模型具有放慢值,請考慮新增額外的容量大於 Analysis Services 執行個體。You can specify multiple instances of Analysis Services in Excel Services settings. When you do this, data models are streamed to these instances in a round-robin fashion for load balancing. If you notice that resource usage on your instance of Analysis Services is excessive or working with data models in the browser has slowed, consider adding an additional instance of Analysis Services for greater capacity.

Analysis Services 執行個體指定為 Excel Services 應用程式設定] 的一部分。如需設定 Excel Services 的 SQL Server 2012 SP1 Analysis Services (SSAS) 的資訊,請參閱 < Manage Excel Services 資料模型設定 (SharePoint Server 2013)The Analysis Services instance is specified as part of Excel Services Application Settings. For information on configuring SQL Server 2012 SP1 Analysis Services (SSAS) for Excel Services, see Manage Excel Services data model settings (SharePoint Server 2013).