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.
Click on Next and it will download the file. Finally, run and install the downloaded file.
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.
Step 2: Click on New and select PerformancePoint Service application.
Step 3: In New PerformancePoint Service application window – provide the Name of the service application, Database server, and Database name.
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.
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.
Step 5: Go to System Settings -> Manage Services on Server.
Search for PerformancePoint Service and click on Start if it is not started.
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
Leave a comment