3 minute read
Custom Development

Simple Way to Create a PPS Dashboard

PerformancePoint Services in SharePoint 2013 is a service that provides flexible tools to help us to create rich dashboards, scorecards, and key performance indicators in web browsers. PerformancePoint Service helps management users to analyse data for better business decisions.

Steps to Create Performance Point Service

First, we have to create a Business intelligence site as shown below:


Once the site gets created, go to “Site Contents”


For designing a dashboard, click on the “Dashboards” library.

Go to ribbon “PERFORMANCE POINT” and click on “Dashboard Designer” as shown below


Launch the Dashboard Designer as shown below


So the first step is to “create a Data Connection”. Right click “Data Connection” and click on “New Data Source”


Various Types of Data Connection available in listed above. Choose “Multidimensional” and “Analysis Services”. Click the OK button as shown in figure below:


Create a connection string by specifying Server Name, Database Name and Cube name. Then Click on Test Data Source. Rename Data Connections as “PPSSSASCon” and Save this. Right click “PerformancePoint Contents”, New and select Report as shown below:


Select Analytic Chart and Click on Ok


Choose Data Source you would like to use. Choose “PPSSSASCon”.


Click finish button. Rename the report as “PPS Chart”

From the Details pane which is on our right side, drag and drop measures and dimensions depends on the requirement.


Right click “PerformancePoint Contents”, New and select Dashboard as shown below:


Click on Dashboard to Create a New Dashboard Page Template as shown below:


Select One Zone Report and Click on Ok


Rename it as PPS Dashboard

Drag and Drop the PPSChart from the Right pane details of the Performance Point Content as shown below:


Save the Dashboard and Deploy the SharePoint site, Right click the “PPS Dashboard” and click on “Deploy to SharePoint”


Create a filter for filtrations of Dashboard


Select members sections and Click Ok


Select Analysis Service Connection “PPSSSASCon” and Next


Select “Select dimendion” button from right side and choose “Calendar Year Desc” as filters and Click on Ok.


Then Select all filters members


After the two steps is done then select “filters measures” Sales Amount


Click Next and “Choose Multi Select Tree”–> Click Finish and Rename Filters as “PPSFilters”


Again Go to “PPSDashboard” and drag and drop the PPS Filters to Dash board section


Now the following PPS Dashboard is ready to use after the deployment

Niraj Tenany

About Niraj Tenany

Niraj is Chief Executive Officer and a Co-founder of Netwoven, responsible for the strategic vision and direction. Niraj has been working with Fortune 500 companies to implement large-scale enterprise systems for the past 25 years.

Prior to founding Netwoven, Niraj led a profitable Enterprise Applications Consulting Practice at Microsoft. His team implemented large scale deployments of enterprise applications like Siebel, Ariba, and SAP with Fortune 500 customers. Niraj’s team also led the design and implementation of OLAP solutions based on the Microsoft platform. Prior to joining Microsoft, Niraj led a profitable Business Intelligence Consulting practice with Oracle Consulting Services.

Niraj has also worked with startup organizations in senior management positions. Niraj was the Director of Consulting Services at Zaplet, a Kleiner Perkins funded company.

Niraj holds a BS in Computer Science from Birla Institute of Technology, India, an MS in Computer Science from State University of New York (SUNY), and an MBA from Duke University’s Fuqua School of Business in North Carolina.


Leave a Reply

Your email address will not be published. Required fields are marked *

Enter Captcha Here :