Advertisement
For this Dashboard, first we have to configure PPS ,In my previous post I have explained about Configuration of PPS in SharePoint 2013.
Facing issues while Configuration PerformancePoint Services we can check below.
Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator
Cannot connect to performance point services contact the administrator for details
- See more at: http://www.dotnetsharepoint.com/2013/06/sharepoint-2013-performancepoint.html#.UwHpMrRrm-U
Facing issues while Configuration PerformancePoint Services we can check below.
Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator
Cannot connect to performance point services contact the administrator for details
facing issues while Configuration PerformancePoint Services we can check below.
The PerformancePoint Service is a SharePoint Server 2013 service application. It enables users to create business intelligence (BI) dashboards that provide insight into an organization's performance. By providing flexible, easy-to-use tools for rich dashboards, scorecards, and key performance indicators (KPIs) in web browsers, that can aggregate their content from multiple sources and help companies make important decisions.
For this demonstration ,I am using
Windows Server 2012.
Microsoft SharePoint Server 2013.
Microsoft SQL Server Analysis Services 2012.
First, we have to create site using SharePoint template “Business Intelligence Center” as shown in below
Once the site gets created, go to Site Contents on “Site Contents”
You can make a design as per your requirement, for designing a dashboard, click on the “Dashboards” library
Go to ribbon “PERFORMANCE POINT” and click on “Dashboard Designer” as shown below
It shows window like this, click “open”
Launch the Dashboard Designer as shown below

For this demonstration ,I am using Analysis Service database . So first step “create a Data Conncetion”. Right click Data Conncetion and click on “New Data Source” context menu.
It will show different types of data sources. choose “Multidimensional” and “Analysis Services” . Click the OK button as shown in figure below
Create a connection string by specifying Server Name ,Database Name and Cube name as shown below
Note: Some times 'Database' remainder empty. please check my Article for that .
Rename the data source to “pps” save the data source. Right click “PerformancePoint Contents”, New and select Report as shown below
It shows some different templates as shown below
choose Data Source you would like to use .choose “pps” .click finish button. Rename the report as “PPS Chart” .
From the Details pane which is on our right hand side, drag and drop measures and dimensions depends on Your requirement ,I drag “ Student SDAPH“ into our “Bottom Axis” section and drag and drop “Total English, Total Hindi, Total Maths” from Measures as shown below
Add one more report which is the “Analytic Grid” report with name “PPS Grid”.same like as Report ,as shown in below
Create Dashboard and deploy it:
Create a dashboard and deploy the same to our SharePoint site. To create a Dashboard, right click on “PerformancePoint Contents” and click on “Dashboard” Choose the “2 rows” dashboard page template. Rename your dashboard to “PPS Dashboard”.
In Details pane, expand “Reports” and then PerformancePoint Contents. Drag and drop the “PPS Chart” into our first row and “PPS Grid” into our second row.
Save the Dashboard and Deploy the SharePoint site, Right click the “PPS Dashboard” and click on “Deploy to SharePoint”.
Use the “Default Site Master Page” and click “Ok” button.
Final report will look like this
Thanks,for sharing this post.
ReplyDeleteIts very use full for me..........
ReplyDeleteGreat Article... Thank you
ReplyDeleteThanks to all :)
ReplyDeleteHi,
ReplyDeleteHow would one setup a connection btw a scorecard and an excel services report?
hi
ReplyDeleteI have made sure that I have started the Service and created Service application. But, whenever I try to create a data source from PerformancePoint Designer, I get the error:
Cannot connect to PerformancePoint Services.Contact the adminstrator for more details.
Hello,
DeletePlese check my article,
http://www.dotnetsharepoint.com/2014/01/cannot-connect-to-performance-point.html#.UwHng7Rrm-U
thanks its work
Deletehi !
ReplyDeleteI want to create reports from a data model power pivot, what you need to know is that my model refers to external data (various sources)! how can i do?
Thank's
excuse me, I forgot to said that everything is done in sharepoint 2013
DeleteGreat Job thanks..
ReplyDeleteWhile making this step: "Go to ribbon “PERFORMANCE POINT” and click on “Dashboard Designer”" I got this error :
ReplyDeleteRequest FAiled unexpected response from server. The status coe of response is 500, The status text of response is 'System.ServiceModel.ServiceActivationException'. null
The UFC is back in Las Vegas this weekend for a big UFC 209 event, and the promotion has rolled out its “Embedded” treatment for a preview.
ReplyDeleteUFC 209
UFC 209 Live Stream , UFC 209 Live
UFC 209 Fight , UFC 209 Fight Card
LAS VEGAS – The outrage was noticeable when it was announced that UFC welterweight contender Demian Maia would be required to accept
It's finally here, namely, UFC 209. But more than that, it feels like the first big fight week week of the year. That's a little bizarre because this.
Jeremy Stephens and Renato Moicano square off at the UFC Fight Night card on April 15. The bout was announced Wednesday on UFC
UFC 209
UFC 209 Live , UFC 209 Fight Card
UFC 209 Live Stream , UFC 209 Fight
Following having a few days and nights with mid-major March Madness championship video games claiming the schoolMarch Madness Live hockey spotlight, the Power 5 March Madness Live Stream conference tournaments commence to take center stage today. These types of are the games that will help define the way the bubble and the rear end of the NCAA March Madness Bracket Tournament bracket shakes away.
ReplyDeleteMarch Madness 2017
On Wednesday, Syracuse, Arkansas, March Madness 2017 Live California, TCU, Ohio Express, Wake Forest, 2017 March Madness Virginia Technology, Texas Tech, Xavier and The south all play video games NCAA March Madness that will either help solidify their at-large berth/seed or make Selection On the more of an troubled day. march madness schedule
One other quick note: I moved Gonzaga back up to the top seed line after a third thoroughly impressive win over a very good Saint Mary's team in the WCC name game. That's not overall, though. The Pac-12 competition champion march madness schedule 2017 could easily find yourself there by the end of the week, particularly if the winner of the Arizona/UCLA semifinal beats Or in it game.
I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. download UC mini
ReplyDeleteGreat job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. There tend to be not many people who can certainly write not so simple posts that artistically. Continue the nice writing UC mini download
ReplyDelete