Configuration of Performance Point Services in SharePoint 2013

Ahamed Fazil Buhari
 
Senior Developer
January 10, 2017
 
Rate this article
 
Views
5664

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

Category : SharePoint

Author Info

Ahamed Fazil Buhari
 
Senior Developer
 
Rate this article
 
Ahamed is a Senior Developer and he has very good experience in the field of Microsoft Technologies, especially SharePoint, Azure, M365, SPFx, .NET and client side scripting - JavaScript, TypeScript, ...read more
 

Leave a comment