Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 3
Posted by: Pravinkumar Dabade ,
on 2/19/2011,
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.
Conclusion
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 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 Book 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 the latest .NET Core 3.0, .NET Standard and C# 8.0 (final release) 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!
Was this article worth reading? Share it with fellow developers too. Thanks!
Pravinkumar, works as a freelance trainer and consultant on Microsoft Technologies. He is having over 10 years of experience in IT and is also a Microsoft Certified Trainer(MCT). He has conducted various corporate trainings on all versions of .NET Technologies including .NET, SharePoint Server, Microsoft SQL Server, Silverlight, ASP.NET, Microsoft PerformancePoint Server 2007 (Monitoring). He is passionate about learning new technologies from Microsoft. You can contact Pravinkumar at dabade[dot]pravinkumar [attherate] gmail[dot]com