天天看點

SharePoint 2010 PerformancePoint Service Application

                                   SharePoint 2010PerformancePoint Service Application

PerformancePoint 原是一組BI報表的制作工具,Moss2007可以和PerformancePointserver進行很好的內建(将PerformancePoint制作好的BI報表內建到Moss網站的網頁中),但是需要進行一些繁瑣的配置。Moss2010中內建了PerformancePointService Application,我們再也不需要為了使用PerformancePoint制作的報表而進行繁瑣的配置了。

本文将介紹一下内容:

·        PerformancePoint Service Application 的配置

·        建立BI站點來使用PerformancePoint

·        使用Dashboard designer 來制作一個簡單的BI報表并釋出到BI網站中

PerformancePointService Application 的配置

a.      啟動PerformancePoint Service Application:打開SharePoint2010 管理中心->Central Administration-> Manage services on server

SharePoint 2010 PerformancePoint Service Application

b.     配置PerformancePoint Service Application:CentralAdministration ->Manage service applications->PerformancePoint ServiceApplication Settings

SharePoint 2010 PerformancePoint Service Application

注意這個步驟可能會出錯,如果沒有配置Secure StoreService。

解決辦法如下:Central Administration ->Secure StoreService,點選”Generate New Key”

SharePoint 2010 PerformancePoint Service Application

輸入密鑰并點選OK

SharePoint 2010 PerformancePoint Service Application

建立BI站點來使用PerformancePoint

                Central Administration ->Application Management->Create site collections

SharePoint 2010 PerformancePoint Service Application

打開剛剛建立的BISite

SharePoint 2010 PerformancePoint Service Application

使用Dashboarddesigner 來制作一個簡單的BI報表并釋出到BI網站中

a.      點選上圖中的Startusing PerformancePoint Services

SharePoint 2010 PerformancePoint Service Application

b.     點選上圖中的 RunDashboard Designer

SharePoint 2010 PerformancePoint Service Application

c.      建立一個Dashboard

SharePoint 2010 PerformancePoint Service Application

d.     選擇布局并點選OK

SharePoint 2010 PerformancePoint Service Application

e.     添加一個資料源,Dashboard可以使用SharePoint List, Database,Report service, Sql analysis service 等作為資料源,這裡我們為了示範簡單,選取SharePointList作為資料源

假如已經建好了一CustomerAnalysis,它存儲有下列資料:

SharePoint 2010 PerformancePoint Service Application

在Dashboarddesigner 中選擇資料連結(DataConnections),左擊選擇建立資料源(NewData Source)

SharePoint 2010 PerformancePoint Service Application

點選OK ,填寫SharePoint site,選擇CustomerAnalysis清單作為資料源,點選測試資料源(Test Data Source)測試成功後将資料源重命名為CustomerAnalysis。

SharePoint 2010 PerformancePoint Service Application
SharePoint 2010 PerformancePoint Service Application

f.       建立一個Scorecard并指定資料源為CustomerAnalysis

在Dashboard Designer 中選中PerformancePoint Content,右擊選擇建立(New)-> Scorecard

SharePoint 2010 PerformancePoint Service Application

選擇SharePoint類型的資料源,點選OK

SharePoint 2010 PerformancePoint Service Application

選擇剛剛建立的資料源CustomerAnalysis,點選 Next

SharePoint 2010 PerformancePoint Service Application

添加KPI,并點選Next

SharePoint 2010 PerformancePoint Service Application

添加Measure Filter, 并點選Next

SharePoint 2010 PerformancePoint Service Application

選擇要統計的客戶記錄點選OK, 點選Next

SharePoint 2010 PerformancePoint Service Application

點選Finish, 将其重命名為CustomerAnalysis

g.      将ScorecardCustomerAnalysis 拖放到Dashboard中

SharePoint 2010 PerformancePoint Service Application
SharePoint 2010 PerformancePoint Service Application

h.     将Dashboard釋出到SharePoint站點

SharePoint 2010 PerformancePoint Service Application

效果如下:

SharePoint 2010 PerformancePoint Service Application

繼續閱讀