管理 Excel Services 資料模型設定 (SharePoint Server 2013)Manage Excel Services data model settings (SharePoint Server 2013)

摘要:設定 Excel Services 的 SQL Server 2012 Analysis Services 資料模型 」 功能的執行個體。Summary: Configure instances of SQL Server 2012 Analysis Services for Data Model functionality in Excel Services.

重要

本文中的步驟適用於 SharePoint Server 2013 Enterprise 中。The steps in this article apply to SharePoint Server 2013 Enterprise.

可以使用 Excel Services 執行個體的 SQL Server 2012 SP1 Analysis Services (SSAS) 執行進階的資料分析計算。本文說明如何註冊、 編輯及取消登錄的 SQL Server 2012 Analysis Services 使用 Excel Services 的執行個體中執行下列計算。Excel Services can use instances of SQL Server 2012 SP1 Analysis Services (SSAS) perform advanced data analysis calculations. This article describes how to register, edit, and unregister instances of SQL Server 2012 Analysis Services for use by Excel Services in performing these calculations.

開始這項作業之前,請參閱下列有關先決條件的資訊:Before you begin this operation, review the following information about prerequisites:

  • 若要執行這些程序,您必須是伺服器陣列管理員群組或您所設定的 Excel Services 服務應用程式的管理員的成員。To perform these procedures, you must be member of the Farm Administrators group or an Administrator for the Excel Services service application that you are configuring.

  • SQL Server 2012 Analysis Services 想要使用的執行個體必須安裝在 SQL Server PowerPivot for SharePoint 模式。The instance of SQL Server 2012 Analysis Services that you plan to use must be installed in SQL Server PowerPivot for SharePoint mode.

登錄 Analysis Services 伺服器Register an Analysis Services server

使用下列程序登錄與 Excel Services 的執行個體的 SQL Server 2012 SP1 Analysis Services (SSAS)。Use the following procedure to register an instance of SQL Server 2012 SP1 Analysis Services (SSAS) with Excel Services.

登錄 Analysis Services 伺服器To register an Analysis Services server

  1. 在管理中心首頁上,按一下 [應用程式管理] 區段中的 [管理服務應用程式]。On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上,按一下 [資料模型On the Manage Excel Services page, click Data Model.

  4. 按一下 [新增伺服器Click Add Server.

  5. 在 [伺服器名稱] 方塊中輸入的 SQL Server 2012 SP1 Analysis Services (SSAS) 您想要新增之執行個體的名稱。In the Server Name box, type the name of the instance of SQL Server 2012 SP1 Analysis Services (SSAS) that you want to add.

  6. (選用) 在 [描述] 方塊中輸入伺服器的描述。Optionally, in the Description box, type a description for the server.

  7. 按一下 [ OK ]。Click OK.

編輯 Analysis Services 伺服器詳細資料Edit Analysis Services server details

使用下列程序編輯伺服器名稱或描述的 SQL Server 2012 SP1 Analysis Services (SSAS) 登錄與 Excel Services 的執行個體。Use the following procedure to edit the server name or description for an instance of SQL Server 2012 SP1 Analysis Services (SSAS) that has been registered with Excel Services.

編輯 Analysis Services 伺服器詳細資料To edit Analysis Services server details

  1. 在管理中心首頁上,按一下 [應用程式管理] 區段中的 [管理服務應用程式]。On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上,按一下 [資料模型On the Manage Excel Services page, click Data Model.

  4. 將滑鼠停留在伺服器上您要編輯、 按一下出現箭號,然後按一下 [編輯]。Hover over the server that you want to edit, click the arrow that appears, and then click Edit.

  5. 更新的伺服器名稱描述] 方塊,並再按一下 [確定]Update the Server Name and Description as needed, and then click OK.

取消登錄 Analysis Services 伺服器Unregister an Analysis Services server

若要移除的執行個體的 SQL Server 2012 SP1 Analysis Services (SSAS) 從 Excel Services 中使用下列程序。Use the following procedure to remove an instance of SQL Server 2012 SP1 Analysis Services (SSAS) from Excel Services.

若要取消登錄 Analysis Services 伺服器To unregister an Analysis Services server

  1. 在管理中心首頁上,按一下 [應用程式管理] 區段中的 [管理服務應用程式]。On the Central Administration home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下您想要管理 Excel Services 服務應用程式。On the Manage Service Applications page, click the Excel Services service application that you want to manage.

  3. 在 [管理 Excel Services] 頁面上,按一下 [資料模型On the Manage Excel Services page, click Data Model.

  4. 將滑鼠停留在您想要編輯、 按一下出現箭號,然後按一下 [刪除的伺服器。Hover over the server that you want to edit, click the arrow that appears, and then click Delete.

  5. 按一下 [刪除確認對話方塊上的[確定]Click OK on the delete confirmation dialog box.

另請參閱See also

其他資源Other Resources

在 SharePoint 中設定 Excel ServicesConfigure Excel Services in SharePoint