SharePoint24x7 It's all about SharePoint.


Article – Configuring PerformancePoint Services (PPS) in SharePoint 2013

What is PerformancePoint Services (PPS)?

As per TechNet:

PerformancePoint Services in SharePoint Server 2013 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs), PerformancePoint Services can help individuals across an organization make informed business decisions that align with companywide objectives and strategy.

PerformancePoint Services lets you create rich dashboards, aggregating content from multiple sources and displaying it in a web browser in an understandable and collaborative environment. The rich interactivity of the dashboards lets you to analyze the latest information and work with the data quickly and easily to identify key opportunities and trends. PerformancePoint Services and its authoring tool Dashboard Designer let you display key performance indicators (KPIs) and data visualizations in the form of scorecards, analytic reports, and filters. You can integrate with SQL Server Reporting Services (SSRS)and Excel Services in addition to create scorecards that bring together data from multiple data sources to track and monitor key drivers of your business.

Configuring PerformancePoint Services is very easy if you have experience already configuring services such as Excel Services, Secure Store Services, PowerPivot, etc…

In this article I’m trying to help you with the various information which are required for configuring PerformancePoint Services service application.

Prerequisites for configuring PPS:

  • SharePoint Server 2013 Enterprise – before we get started with the configuration of PPS, we need to make sure that we have SharePoint Server 2013 Enterprise edition in order to use PPS. PPS is available only with the Enterprise edition of SharePoint Server.
  • ADOMD.NET – SharePoint 2013 Prerequisites Installer installs ADOMD.NET 9.0 automatically in to your environment. However, PPS requires ADOMD.NET 10 and ADOMD.NET 11 to be installed in your environment.
Task 1 – Verify what version of ADOMD.NET is installed in your environment
  • Navigate to C:\Program Files\Microsoft.NET\ADOMD.NET\
  • If you have ADOMD.NET 9, ADOMD.NET 10 and ADOMD.NET 11 installed, you will see something similar to the followingADOMD.NET install folder
  • If you don’t have either 100 or 110 folders, which means you don’t have either ADOMD.NET 10 or ADOMD.NET 11 installed in your environment. Depending on the version you need to install, you can use either of the following links to download and install ADOMD.NET:
Task 2 – Grant Application Pool Service Account access to SharePoint Content Database
  • Open SharePoint 2013 Management Shell. Make sure to Run as Administrator.
  • Grant application pool service account access to the content database using following cmdlets
    $webApp = Get-SPWebApplication


Task 3 – Create PerformancePoint Service Application instance
  • Open SharePoint 2013 Central Administration web site
  • Navigate to Manage service applications page from Application Management section
  • Select New from the Create group in the ribbon and select PerformancePoint Service ApplicationNew service application
  • Enter a Name, Database Server, Database Name and Application Pool details and click Create.Capture2
  • Click OK in the service application instance creation conformation page
Task 4 – Start PerformancePoint Services service
  • Open SharePoint 2013 Central Administration web site
  • Navigate to Manage services on server from System Settings section
  • Check the status of the Performance Point Service service. Start it if it’s not started already.

Posted by Joy