PowerPivot for SharePoint (SSAS)PowerPivot for SharePoint (SSAS)

PowerPivot for SharePoint 是以 SharePoint 模式執行的 Analysis ServicesAnalysis Services 伺服器。PowerPivot for SharePoint is a Analysis ServicesAnalysis Services server running in SharePoint mode. PowerPivot for SharePoint 提供將 PowerPivot 資料裝載於 SharePoint 伺服器陣列的功能。PowerPivot for SharePoint provides server hosting of PowerPivot data in a SharePoint farm. PowerPivot 資料是您使用下列其中一個項目建立的分析資料模型:PowerPivot data is an analytical data model that you build using one of the following:

  • PowerPivot for Excel 2010 增益集The PowerPivot for Excel 2010 add-in

  • Excel 2013Excel 2013

適用範圍:Applies to: PowerPivot for SharePointPowerPivot for SharePoint2013 |PowerPivot for SharePointPowerPivot for SharePoint 2010適用範圍:Applies to: PowerPivot for SharePointPowerPivot for SharePoint 2013 | PowerPivot for SharePointPowerPivot for SharePoint 2010

這些資料的伺服器裝載需要 SharePoint、Excel Services 和 PowerPivot for SharePoint 安裝。Server hosting of that data requires SharePoint, Excel Services, and an installation of PowerPivot for SharePoint. 資料載入到 PowerPivot for SharePoint 執行個體上,在此處可透過伺服器為 Excel 2010 活頁簿提供的 PowerPivot 資料重新整理功能或是為 Excel 2013 活頁簿提供的 SharePoint 2013 Excel Services,依排程間隔重新整理資料。Data is loaded on PowerPivot for SharePoint instances where it can be refreshed at scheduled intervals using the PowerPivot data refresh capability that the server provides for Excel 2010 workbooks or that SharePoint 2013 Excel Services provides for Excel 2013 workbooks.

PowerPivot for SharePoint 2013PowerPivot for SharePoint 2013

SQL Server 2014SQL Server 2014PowerPivot for SharePointPowerPivot for SharePoint支援MicrosoftMicrosoft SharePoint 2013 excel Services 使用包含資料模型和Reporting ServicesReporting Services Power View 報表的 excel 活頁簿。PowerPivot for SharePointPowerPivot for SharePoint supports MicrosoftMicrosoft SharePoint 2013 Excel Services usage of Excel workbooks containing data models and Reporting ServicesReporting Services Power View reports.

SharePoint 2013 中的 Excel Services 包含資料模型功能,可在瀏覽器中啟用與 PowerPivot 活頁簿的互動。Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a PowerPivot workbook in the browser. 您不需要將 PowerPivot for SharePoint 2013 增益集部署至伺服器陣列。You do not need to deploy the PowerPivot for SharePoint 2013 add-in into the farm. 您只需要在 SharePoint 模式下安裝 Analysis ServicesAnalysis Services 伺服器,並且在 Excel Services [資料模型] 設定中註冊伺服器即可。You only need to install an Analysis ServicesAnalysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

若部署 PowerPivot for SharePoint 2013 增益集,會在 SharePoint 伺服器陣列中啟用其他功能與特性。Deploying the PowerPivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm. 其他功能包括 PowerPivot 圖庫、排程資料重新整理及 PowerPivot 管理儀表板。The additional features include PowerPivot Gallery, Schedule Data Refresh, and the PowerPivot Management Dashboard.

SSAS PowerPivot 模式 2 伺服器部署SSAS PowerPivot Mode 2 Server Deployment

PowerPivot for SharePoint 2010PowerPivot for SharePoint 2010

PowerPivot for SharePoint 2010 提供將 PowerPivot 資料裝載於 SharePoint 2010 伺服器陣列的功能。PowerPivot for SharePoint 2010 provides server hosting of PowerPivot data in a SharePoint 2010 farm. PowerPivot 資料是使用 PowerPivot for Excel 增益集在 Excel 中建立的分析資料模型。PowerPivot data is an analytical data model that you build in Excel using the PowerPivot for Excel add-in. 這些資料的伺服器裝載需要 SharePoint 2010、Excel Services 和 PowerPivot for SharePoint 安裝。Server hosting of that data requires SharePoint 2010, Excel Services, and an installation of PowerPivot for SharePoint. 資料載入到伺服器陣列中的 PowerPivot for SharePoint 執行個體,在此處可透過伺服器提供的 PowerPivot 資料重新整理功能,依排程間隔重新整理資料。Data is loaded on PowerPivot for SharePoint instances in the farm, where it can be refreshed at scheduled intervals using the PowerPivot data refresh capability that the server provides.

PowerPivot for SharePoint 2010 的元件Components of PowerPivot for SharePoint 2010

PowerPivot for SharePoint 實作為共用服務,這表示內建功能和基礎結構可用來管理、保護和使用 PowerPivot 服務應用程式。PowerPivot for SharePoint is implemented as a shared service, which means that the built-in features and infrastructure can be used to administer, secure, and use a PowerPivot service application. 伺服器和資料庫探索、重新導向和連接管理全都是在伺服器陣列層級管理。Server and database discovery, redirection, and connection management is all managed at the farm level. 管理中心提供用來管理伺服器識別、伺服器狀態和組態屬性之服務的管理介面。Central Administration provides the administrative interface to the services used to manage server identity, server state, and configuration properties.

PowerPivot for SharePoint 的完整部署包含在 SharePoint 伺服器陣列中與 Excel 和 Excel Services 整合的用戶端與伺服器元件。A complete deployment of PowerPivot for SharePoint includes client and server components that integrate with Excel and Excel Services in a SharePoint farm. Excel 活頁簿內的 PowerPivot 資料是一種 Analysis Services 資料庫,它需要 Analysis Services xVelocity 記憶體中分析引擎 (VertiPaq) 以載入和查詢資料。The PowerPivot data inside an Excel workbook is an Analysis Services database that requires an Analysis Services xVelocity in-memory analytics engine (VertiPaq) to load and query the data. 在用戶端工作站上,xVelocity 引擎會在 Excel 中以同處理序執行。On a client workstation, the xVelocity engine runs in-process within Excel. 在 SharePoint 伺服器陣列中,Analysis Services 會在應用程式伺服器上執行,並與處理 PowerPivot 資料要求的相關服務搭配使用。On a SharePoint farm, Analysis Services runs on an application server where it is paired with related services that handle requests for PowerPivot data. 下圖說明 PowerPivot 用戶端與伺服器元件:The following diagram illustrates PowerPivot client and server components:

GMNI_GeminiArch2GMNI_GeminiArch2

PowerPivot Web 服務在 Web 應用程式伺服器上執行。PowerPivot Web service runs on a web application server. 它會將來自 Web 應用程式的要求導向至伺服器陣列中的 PowerPivot 系統服務執行個體。It redirects requests from the web application to a PowerPivot System Service instance in the farm.

PowerPivot 系統服務會將載入要求發給 Analysis Services 伺服器,以及管理已載入記憶體之資料的進行中連接,並且於不再使用資料或系統資源有競爭時,快取或卸載資料。PowerPivot System Service issues load requests to the Analysis Services server and manages ongoing connections to data that is already loaded in memory, caching or unloading data if it is no longer used or when there is contention for system resources. 它也會追蹤使用者活動。It also tracks user activity. 在報表中收集及呈現伺服器健全狀況資料和其他使用量資料,以表示系統的執行效能。Server health data and other usage data is gathered and presented in reports to indicate how well the system is performing.

SharePoint 整合模式的 Analysis Service 伺服器執行個體會完成部署。An Analysis Service server instance in SharePoint integrated mode completes the deployment. 它會載入、查詢和卸載資料。It loads, queries, and unloads data. 如果活頁簿設定為使用 PowerPivot 資料重新整理,它也會處理資料。It also processes data if the workbook is configured for PowerPivot data refresh. 每個執行個體會與相同安裝中的本機 PowerPivot 系統服務緊密結合在一起。Each instance is tightly coupled with the local PowerPivot System Service that is part of the same installation.

本節內容In This Section

管理中心的 PowerPivot 伺服器管理和組態PowerPivot Server Administration and Configuration in Central Administration

使用 Windows PowerShell 的 PowerPivot 組態PowerPivot Configuration using Windows PowerShell

PowerPivot Configuration ToolsPowerPivot Configuration Tools

PowerPivot 驗證及授權PowerPivot Authentication and Authorization

PowerPivot 健全狀況規則 - 設定PowerPivot Health Rules - Configure

PowerPivot 管理儀表板和使用量資料PowerPivot Management Dashboard and Usage Data

PowerPivot 圖庫PowerPivot Gallery

PowerPivot 資料存取PowerPivot Data Access

PowerPivot 資料重新整理PowerPivot Data Refresh

PowerPivot 資料摘要PowerPivot Data Feeds

PowerPivot BI 語義模型連接 (. bism)PowerPivot BI Semantic Model Connection (.bism)

其他章節In other sections

其他主題Additional topics

升級 PowerPivot for SharePointUpgrade PowerPivot for SharePoint

PowerPivot for SharePoint 2013 安裝PowerPivot for SharePoint 2013 Installation

PowerPivot for SharePoint 的 PowerShell 參考PowerShell Reference for PowerPivot for SharePoint

SQL Server 2014 自助商業智慧的授權拓撲和成本範例Example License Topologies and Costs for SQL Server 2014 Self-Service Business Intelligence

另請參閱See Also

PowerPivot 規劃與部署 PowerPivot Planning and Deployment
PowerPivot for SharePoint 災害復原Disaster Recovery for PowerPivot for SharePoint