Configuration of Performance Point Services in SharePoint 2013


Ahamed Fazil Buhari
SharePoint Developer
Published On :   10 Jan 2017
Visit Count
Today :  3    Total :   1305
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

SharePoint Office 365 Tool
Simple & Powerful Tool for Migration, Security & Reporting. Free Trial


In this article we are going to see, How to Configure PerformancePoint Services in SharePoint 2013. Before going into configuration, let me give you some idea about PerformancePoint. Well, PerformancePoint is all about creating dashboards. We can create charts, filters, scorecards, KPIs (Key Performance Indicator) and all kinds of business analytics tools.

In order to get the PerformancePoint Services up and running, we need to install two things – ADOMD.NET version 10 and ADOMD.NET version 11. You can download this both by clicking on their respective names.

To check which version of ADOMD.NET version has installed on your server, go to C:\Program Files\Microsoft.NET\ and you can find the folder name with their versions. You can download and install the missing version.

When you click on the download button it will ask you to choose which files you want to download. Just scroll down until you find “SQLSERVER2008_ASADOMD10.msi” 64-bit for version 10 and “SQL_AS_ADOMD.msi” for version 11. For example, here I’m trying to download version 10.

image

Click on Next and it will download the file. Finally, run and install the downloaded file.

image

We have to grant our Application Pool Service Account access to our SharePoint Content Database. So, for that open up the SharePoint 2013 Management Shell, remember to run as Administrator and run this two simple line,

$webApp = Get-SPWebApplication http://ahamedSP.devsite.com

$webApp.GrantAccessToProcessIdentity("devsite\sp_serviceacc")

Now let’s get into the core part of this article i.e. Configuration of PerformancePoint Services. Please follow the below steps for that,

Step 1: Go to Central Admin and click on Manage service applications.

image

Step 2: Click on New and select PerformancePoint Service application.

image

Step 3: In New PerformancePoint Service application window - provide the Name of the service application, Database server, and Database name.

image

Here, I’ve used an existing application pool but you may need to create a new application pool as per your requirement. Click on Create.

image

Step 4: You will get a message as shown in the below screenshot and you can notice the warning message “Connecting to Microsoft SQL Server Analysis Services:” no need to worry about this because in one of my previous article I’ve explained on PowerPivot Configuration. So this is just a warning letting us know that we need to do that, but you can simply avoid this warning message if you have done that PowerPivot Configuration already.

image

Step 5: Go to System Settings -> Manage Services on Server.

image

Search for PerformancePoint Service and click on Start if it is not started.

image

Alright we’re good and the next thing we need to do is go ahead and configure our PerformancePoint Service to use the Secure Store. We can see that in my upcoming article. Thank you for reading

Happy Coding

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

KWizCom Forms App