Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 3
Posted by: Pravinkumar Dabade
in Category SharePoint
Abstract: In the first part of this series Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS we saw how to create a SharePoint Site and Scorecard with KPIs. In the second part, we saw how to create a Chart Report and a Grid Report. In this final part of this article series, we are going to see how to create a Dashboard and deploy it to SharePoint Site.
In the first part of the series Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS we saw how to create a SharePoint Site and Scorecard with KPIs. In the second part of this series, we saw how to create a Chart Report and a Grid Report. If you have not read Part I and II, I strongly commend you do so before continuing with this article.
In this final part, we are going to see how to create a Dashboard and deploy it to SharePoint Site.
Step 1: Right click PerformancePoint Content > New > Dashboard which will use a Dashboard template ‘Header, 2 Columns’ as shown below:
Rename your Dashboard as ‘PDW Demo Dashboard’. Your Dashboard will look similar to the one shown below :
Step 2: Now let’s modify the height of our Header section. For this right click the header section and go to “Zone Settings” from the context menu. Click on the Size Tab and change its height from 10 to 50, as shown below:
Now let’s add our Chart Report that we created in our previous article to our Header Section, Scorecard to the Left Column of our dashboard and Grid Report to the Right column of our Dashboard from the ‘Details’ window as shown below –
Step 3: That’s all. Your Dashboard is ready. To preview your Dashboard, right click and click on Deploy as shown below :
Once your Dashboard is deployed successfully, you should see it on your SharePoint Site as shown below:
That’s it! You have successfully created a Dashboard using Sharepoint PerformancePoint and Analysis Services (SSAS) and deployed it a SharePoint Site.
In this article series, we have seen how to create a Dashboard using PerformancePoint Services Dashboard Designer Tool and deploy it to SharePoint Site. For this demonstration we have used Microsoft Multidimensional Data Source that is SQL Server Analysis Services Database.
This article has been editorially reviewed by Suprotim Agarwal.
C# and .NET have been around for a very long time, but their constant growth means there’s always more to learn.
We at DotNetCurry are very excited to announce the The Absolutely Awesome Book on C# and .NET. This is a 500 pages concise technical eBook available in PDF, ePub (iPad), and Mobi (Kindle).
Organized around concepts, this eBook aims to provide a concise, yet solid foundation in C# and .NET, covering C# 6.0, C# 7.0 and .NET Core, with chapters on .NET Standard and the upcoming C# 8.0 too. Use these concepts to deepen your existing knowledge of C# and .NET, to have a solid grasp of the latest in C# and .NET OR to crack your next .NET Interview.
Click here to Explore the Table of Contents or Download Sample Chapters!