SharePoint Pals
 | Sign In
Configuration of Performance Point Services in SharePoint 2013
by Ahamed Fazil Buhari 10 Jan 2017
Author
SharePoint Developer
Visits   
Today  :   28     Total  :    347

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

blog comments powered by Disqus

SharePoint Pals

Pals
SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile

Training

Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community




SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to articles@sharepointpals.com in a word document.

Related Resources

Recent Tweets

Twitter January 15, 00:25
How To Enable Target Value And Actual Value In #D3 Gauge Chart https://t.co/VxSi4QnNrC

Twitter January 15, 00:24
How To Open #SharePoint List Hyperlink Column In Modal #Popup Window https://t.co/EQ7HkoZDkX

Twitter January 15, 00:24
Quick Introduction To #Asp.NetCore And It’s Features https://t.co/zAXObHCFpH

Twitter January 15, 00:22
How To Configure #PerformancePoint Services To Use Secure Store In #SharePoint 2013 https://t.co/LEwnUoI7EY

Twitter January 15, 00:21
How To Block Or Disable #Office365 Services https://t.co/Yvp2VPFIRP

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation