Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 1

<!DOCTYPE html> <html lang="en"> <head id="ctl00_Head1"><meta charset="utf-8" /><title> Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 1 | DotNetCurry </title><meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" /><meta name="description" content="In this article series, we are going to see how to create KPIs (Key Performance Indicator), Scorecard, Reports (Chart Report and Grid Report) and Dashboard using SharePoint PerformancePoint Services 2010 Dashboard Designer Tool. For this demonstration, we will be using the sample data from SQL Server Analysis Services (SSAS). Once our Dashboard is ready, we will then deploy it to our SharePoint Site." /><meta name="keywords" content="SharePoint" /><meta name="author" content="DotNetCurry.com" /><meta name="CCBot" content="nofollow" /><link rel="shortcut icon" href="img/favicon.ico" /><link rel="icon" type="image/ico" href="img/favicon.ico" /><link rel="stylesheet" href="js/font-awesome/css/font-awesome.min.css" /><link rel="canonical" href="https://www.dotnetcurry.com/ShowArticle.aspx?ID=650" /><link href="/content/site?v=dSwaMsW0iplPE-tk0JGVwhcZRf6VKKqSg-lTdPGvZso1" rel="stylesheet"/> <style>.async-hide { opacity: 0 !important} </style>    <script> !function(f,b,e,v,n,t,s){if(f.fbq)return;n=f.fbq=function(){n.callMethod? n.callMethod.apply(n,arguments):n.queue.push(arguments)};if(!f._fbq)f._fbq=n; n.push=n;n.loaded=!0;n.version='2.0';n.queue=[];t=b.createElement(e);t.async=!0; t.src=v;s=b.getElementsByTagName(e)[0];s.parentNode.insertBefore(t,s)}(window, document,'script','https://connect.facebook.net/en_US/fbevents.js'); fbq('init', '1902706389940870', { //em: 'insert_email_variable' }); fbq('track', 'PageView'); </script> <noscript><img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1902706389940870&ev=PageView&noscript=1" /></noscript>    <script> !function(e,t,n,s,u,a){e.twq||(s=e.twq=function(){s.exe?s.exe.apply(s,arguments):s.queue.push(arguments); },s.version='1.1',s.queue=[],u=t.createElement(n),u.async=!0,u.src='//static.ads-twitter.com/uwt.js', a=t.getElementsByTagName(n)[0],a.parentNode.insertBefore(u,a))}(window,document,'script'); // Insert Twitter Pixel ID and Standard Event data below twq('init','nw0gz'); twq('track','PageView'); </script>  </head> <body> <form name="aspnetForm" method="post" action="./ShowArticle.aspx?ID=650" id="aspnetForm"> <div> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE0MDk2ODQwMTdkZJysVikQVHzjAtZqOeUvZO1Bu1pl" /> </div> <div> <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="A9C58E29" /> </div> <div class="wrapper">  <header class="header header-megamenu"> <nav class="navbar navbar-default" role="navigation"> <div class="container">   <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button>  <a class="navbar-brand" href="https://www.dotnetcurry.com"> <img src="/img/dnc-logo-small.jpg" class="img-responsive" alt="DNC Magazine" /> </a> </div>  <div class="navbar-social pull-right visible-xs-block, hidden-xs"> <a href="https://www.facebook.com/dotnetcurry"><img src="/img/icon/fb.png" class="img-responsive" alt="DotNetCurry's Official Facebook Account" /></a> <a href="https://www.twitter.com/dotnetcurry"><img src="/img/icon/twit.png" class="img-responsive" alt="DotNetCurry's Official Twitter Account" /></a> <a href="https://github.com/dotnetcurry"><img src="/img/icon/git.png" class="img-responsive" alt="DotNetCurry's Official Github Account" /></a> </div>  <div class="collapse navbar-collapse navbar-ex1-collapse"> <ul class="nav navbar-nav"> <li class="dropdown megamenu"> <a href="#" class="dropdown-toggle" data-toggle="dropdown">Tutorials <span class="fa fa-angle-down"></span></a> <ul class="dropdown-menu"> <li> <div class="row"> <div class="col-md-3"> <h5>ASP.NET</h5> <a href="https://www.dotnetcurry.com/tutorials/aspnet">ASP.NET</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-mvc">ASP.NET MVC</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-core">ASP.NET Core</a> <a href="https://www.dotnetcurry.com/tutorials/sharepoint">SharePoint</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-ajax" class="last">ASP.NET AJAX</a> <h5>Patterns and Practices</h5> <a href="https://www.dotnetcurry.com/tutorials/software-gardening">Software Gardening</a> <a href="https://www.dotnetcurry.com/tutorials/patterns-practices">Design Patterns</a> </div> <div class="col-md-3"> <h5>.NET</h5> <a href="https://www.dotnetcurry.com/tutorials/csharp">C#</a> <a href="https://www.dotnetcurry.com/tutorials/visualstudio">Visual Studio</a> <a href="https://www.dotnetcurry.com/tutorials/vsts-tfs">VSTS (Azure DevOps) & TFS</a> <a href="https://www.dotnetcurry.com/tutorials/linq">LINQ</a> <a href="https://www.dotnetcurry.com/tutorials/entityframework">Entity Framework</a> <a href="https://www.dotnetcurry.com/tutorials/dotnetframework">.NET Framework</a> <a href="https://www.dotnetcurry.com/tutorials/dotnet-standard-core">.NET Standard & .NET Core</a> <a href="https://www.dotnetcurry.com/tutorials/wpf">WPF</a> <a href="https://www.dotnetcurry.com/tutorials/wcf">WCF</a> <a href="https://www.dotnetcurry.com/tutorials/winforms">WinForms</a> </div> <div class="col-md-3"> <h5>Cloud and Mobile</h5> <a href="https://www.dotnetcurry.com/tutorials/windows-azure">Microsoft Azure</a> <a href="https://www.dotnetcurry.com/tutorials/devops">DevOps</a> <a href="https://www.dotnetcurry.com/tutorials/xamarin">Xamarin</a> <a href="https://www.dotnetcurry.com/tutorials/powershell">Powershell</a> <a href="https://www.dotnetcurry.com/tutorials/machine-learning-ai">Machine Learning & AI</a> <a href="https://www.dotnetcurry.com/tutorials/windows-store">UWP & Windows Store</a> <a href="https://www.dotnetcurry.com/tutorials/windowsphone" class="last">Windows Phone</a> <h5>Useful</h5> <a href="https://www.dotnetcurry.com/tutorials/dotnetinterview">.NET Interview Q&A</a> <a href="https://www.dotnetcurry.com/tutorials/product-articles-review">Product Reviews</a> <a href="https://www.dotnetcurry.com/tutorials/general-programming-topics">General Topics</a> </div> <div class="col-md-3"> <h5>JavaScript</h5> <a href="https://www.dotnetcurry.com/tutorials/jquery-aspnet">jQuery</a> <a href="https://www.dotnetcurry.com/tutorials/angularjs">Angular</a> <a href="https://www.dotnetcurry.com/tutorials/typescript">TypeScript</a> <a href="https://www.dotnetcurry.com/tutorials/nodejs">Node.js</a> <a href="https://www.dotnetcurry.com/tutorials/reactjs">React.js</a> <a href="https://www.dotnetcurry.com/tutorials/backbonejs">Backbone.js</a> <a href="https://www.dotnetcurry.com/tutorials/html5-javascript">HTML5 & JavaScript</a> <a href="https://www.dotnetcurry.com/tutorials/bootstrap-css">Bootstrap & CSS</a> </div> <div class="col-md-3"> <h5>Publications</h5> <a href="http://www.jquerycookbook.com/">Books</a> <a href="https://www.dotnetcurry.com/magazine/" class="last">Magazines</a> <h5>Older Technologies</h5> <a href="https://www.dotnetcurry.com/tutorials/silverlight">Silverlight</a> <a href="https://www.dotnetcurry.com/tutorials/expression-web">Expression Web</a> <a href="https://www.dotnetcurry.com/tutorials/expression-blend">Expression Blend</a> <a href="https://www.dotnetcurry.com/tutorials/windows-vista">Windows Vista</a> <a href="https://www.dotnetcurry.com/tutorials/microsoft-word">Word 2007</a> <a href="https://www.dotnetcurry.com/tutorials/microsoft-outlook">Outlook 2007</a> <a href="#"></a> </div> </div> </li> </ul> </li> <li class="dropdown megamenu"> <a href="#" class="dropdown-toggle" data-toggle="dropdown">Featured <span class="fa fa-angle-down"></span></a> <ul class="dropdown-menu"> <li> <div class="row"> <div class="col-md-3 col-xs-12"> <div class="header-post"> <a href="https://www.dotnetcurry.com/angular/1385/angular-4-cheat-sheet"> <div class="hp-thumb"> <img data-src="/img/header/1385.jpg" class="img-responsive lazyload" alt="" /> </div> </a> <date>Aug 30, 2017</date> <h4><a href="https://www.dotnetcurry.com/angular/1385/angular-4-cheat-sheet">Angular 4 Development Cheat Sheet</a></h4> <p class="hidden-xs">A quick reference guide to get you going with Angular development. It uses Angular v4 with TypeScript.</p> </div> </div> <div class="col-md-3 col-xs-12"> <div class="header-post"> <a href="https://www.dotnetcurry.com/patterns-practices/1364/error-handling-dotnet-projects"> <div class="hp-thumb">  <img data-src="/img/header/1364.jpg" class="img-responsive lazyload" alt="" /> </div> </a> <date>May 12, 2017</date> <h4><a href="https://www.dotnetcurry.com/patterns-practices/1364/error-handling-dotnet-projects">Error Handling in Large .NET Projects - Best Practices</a></h4> <p class="hidden-xs">Learn some effective error handling strategies that you can use in your .NET projects.</p> </div> </div> <div class="col-md-3 col-xs-12"> <div class="header-post"> <a href="https://www.dotnetcurry.com/patterns-practices/1375/behavior-driven-development-bdd"> <div class="hp-thumb"> <img data-src="/img/header/1375.jpg" class="img-responsive lazyload" alt="" /> </div> </a> <date>July 3, 2017</date> <h4><a href="https://www.dotnetcurry.com/patterns-practices/1375/behavior-driven-development-bdd">Behavior Driven Development (BDD) – an in-depth look</a></h4> <p class="hidden-xs">Learn how Behavior Driven Development (BDD) works with a real-world example of how to use it.</p> </div> </div> <div class="col-md-3 col-xs-12"> <div class="header-post"> <a href="https://www.dotnetcurry.com/patterns-practices/1305/aspect-oriented-programming-aop-csharp-using-solid"> <div class="hp-thumb"> <img data-src="/img/header/1305.jpg" class="img-responsive lazyload" alt="" /> </div> </a> <date>Sep 25, 2016</date> <h4><a href="https://www.dotnetcurry.com/patterns-practices/1305/aspect-oriented-programming-aop-csharp-using-solid">Aspect Oriented Programming (AOP) in C# with SOLID</a></h4> <p class="hidden-xs">Aspect Oriented Programming (AOP) in C# using SOLID principles, with challenges and solutions.</p> </div> </div> <div class="col-md-3 col-xs-12"> <div class="header-post"> <a href="https://www.dotnetcurry.com/javascript/1359/javascript-frameworks-aspnet-mvc-developer"> <div class="hp-thumb"> <img data-src="/img/header/1359.jpg" class="img-responsive lazyload" alt="" /> </div> </a> <date>Sep 25, 2016</date> <h4><a href="https://www.dotnetcurry.com/javascript/1359/javascript-frameworks-aspnet-mvc-developer">JavaScript Frameworks for ASP.NET MVC Developers</a></h4> <p class="hidden-xs">Learn about a few JavaScript frameworks, and which one will be a good fit in your ASP.NET MVC apps</p> </div> </div> </div> </li> </ul> </li> <li class="dropdown megamenu"> <a href="https://www.dotnetcurry.com/magazine/">.NET Magazines</a> </li> <li class="dropdown dropdown-v1"> <a href="#" class="dropdown-toggle" data-toggle="dropdown">About<span class="fa fa-angle-down"></span></a> <ul class="dropdown-menu"> <li><a href="https://www.dotnetcurry.com/About.aspx">About Us</a></li> <li><a href="https://www.dotnetcurry.com/WriteForUs.aspx">Write For Us</a></li> <li><a href="https://www.dotnetcurry.com/Contact.aspx">Contact Us</a></li> </ul> </li>  </ul> </div>  </div> </nav> </header>   <div class="container"> <div class="clearfix divborder"> <div class="col-md-8 column"> <div class="col-md-12 articlebox row"> <div class="articletitle"> <h1 class="articlehead"> <span id="ctl00_MainContent_lblTitle">Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 1</span> </h1> <b>Posted by: </b> <a id="ctl00_MainContent_lnkAddedBy" href="Author.aspx?AuthorName=Pravinkumar Dabade">Pravinkumar Dabade</a> , on 2/11/2011, in <b> Category </b> <a id="ctl00_MainContent_lnkCategory" href="BrowseArticles.aspx?CatID=65">SharePoint</a> <br /> </div> <div class="articlestats"> <div class="stats1"> <b>Views: </b> 119824 <br/> </div> </div> <div class="articleabstract"> <b>Abstract: </b> In this article series, we are going to see how to create KPIs (Key Performance Indicator), Scorecard, Reports (Chart Report and Grid Report) and Dashboard using SharePoint PerformancePoint Services 2010 Dashboard Designer Tool. For this demonstration, we will be using the sample data from SQL Server Analysis Services (SSAS). Once our Dashboard is ready, we will then deploy it to our SharePoint Site. </div> <div class="socialshare"> <a class="resp-sharing-button__link" id="fbsharelinktop" target="_blank" aria-label=""> <div class="resp-sharing-button resp-sharing-button--facebook resp-sharing-button--small"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg version="1.1" x="0px" y="0px" width="24px" height="24px" viewBox="0 0 24 24" enable-background="new 0 0 24 24" xml:space="preserve"> <g> <path d="M18.768,7.465H14.5V5.56c0-0.896,0.594-1.105,1.012-1.105s2.988,0,2.988,0V0.513L14.171,0.5C10.244,0.5,9.5,3.438,9.5,5.32 v2.145h-3v4h3c0,5.212,0,12,0,12h5c0,0,0-6.85,0-12h3.851L18.768,7.465z"/> </g> </svg> <span></span> </div> </div> </a> <a class="resp-sharing-button__link" id="twtsharelinktop" target="_blank" aria-label=""> <div class="resp-sharing-button resp-sharing-button--twitter resp-sharing-button--small"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg version="1.1" x="0px" y="0px" width="24px" height="24px" viewBox="0 0 24 24" enable-background="new 0 0 24 24" xml:space="preserve"> <g> <path d="M23.444,4.834c-0.814,0.363-1.5,0.375-2.228,0.016c0.938-0.562,0.981-0.957,1.32-2.019c-0.878,0.521-1.851,0.9-2.886,1.104 C18.823,3.053,17.642,2.5,16.335,2.5c-2.51,0-4.544,2.036-4.544,4.544c0,0.356,0.04,0.703,0.117,1.036 C8.132,7.891,4.783,6.082,2.542,3.332C2.151,4.003,1.927,4.784,1.927,5.617c0,1.577,0.803,2.967,2.021,3.782 C3.203,9.375,2.503,9.171,1.891,8.831C1.89,8.85,1.89,8.868,1.89,8.888c0,2.202,1.566,4.038,3.646,4.456 c-0.666,0.181-1.368,0.209-2.053,0.079c0.579,1.804,2.257,3.118,4.245,3.155C5.783,18.102,3.372,18.737,1,18.459 C3.012,19.748,5.399,20.5,7.966,20.5c8.358,0,12.928-6.924,12.928-12.929c0-0.198-0.003-0.393-0.012-0.588 C21.769,6.343,22.835,5.746,23.444,4.834z"/> </g> </svg> <span></span> </div> </div> </a> <a class="resp-sharing-button__link" id="linkdinsharelinktop" target="_blank" aria-label=""> <div class="resp-sharing-button resp-sharing-button--linkedin resp-sharing-button--small"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg xmlns="https://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M6.5 21.5h-5v-13h5v13zM4 6.5C2.5 6.5 1.5 5.3 1.5 4s1-2.4 2.5-2.4c1.6 0 2.5 1 2.6 2.5 0 1.4-1 2.5-2.6 2.5zm11.5 6c-1 0-2 1-2 2v7h-5v-13h5V10s1.6-1.5 4-1.5c3 0 5 2.2 5 6.3v6.7h-5v-7c0-1-1-2-2-2z"/></svg> <span></span> </div> </div> </a>  </div> </div> <div id="articleBody" class="col-md-12 row"> <p align="justify"><font size="2" face="Verdana">In this article series, we are going to see how to create KPIs (Key Performance Indicator), Scorecard, Reports (Chart Report and Grid Report) and Dashboard using SharePoint Performance Point Services Dashboard Designer Tool. For this demonstration, we will be using the sample data from SQL Server Analysis Services. Once our Dashboard is ready, we will then deploy it to our SharePoint Site.</font></p> <p align="justify"><font size="2" face="Verdana">This article series is divided in three different parts – </font></p> <p align="justify"><font face="Verdana"><font size="2"><b><u>Part I</u></b> – In the first part, we will see how to create a SharePoint Site using Business intelligence Center and design a Scorecard with KPIs using SQL Server Analysis Services (SSAS) Data Source.</font></font></p> <p align="justify"><font face="Verdana"><font size="2"><b><u>Part II</u></b> – In the second part, we will see how to create a Chart report and Grid Report using SQL Server Analysis Services Data Source. Update: Read Part II <a href="https://www.dotnetcurry.com/ShowArticle.aspx?ID=654">Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 2</a> </font></font></p> <p align="justify"><font face="Verdana"><font size="2"><b><u>Part III</u></b> – In the third part, we will see how to create a Dashboard and consolidate the Scorecard, Chart Report and Grid Report which we have designed in Part – I and Part – II. We will then deploy this Dashboard to a SharePoint Site.</font></font></p> <p align="justify"><font size="2" face="Verdana">So, let’s get started with Part I and see how to create a SharePoint Site using Business intelligence Center and design a Scorecard with KPIs using SQL Server Analysis Services (SSAS) Data Source. </font></p> <p align="justify"><font size="2" face="Verdana">We will first create a SharePoint Site using a Template Business Intelligence Center as shown in Step 1.</font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 1:</b> Click on Start button and go to SharePoint 2010 Central Administrator tool as shown below – </font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="sharepoint central administrator" alt="sharepoint central administrator" src="https://www.dotnetcurry.com/images/sharepoint/sharepointcentraladministrator0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">This step will open a web site. From this website, click on <b>’Create site Collections’</b> from <b>‘Application Management’</b> group as shown below :</font></p> <p align="justify"><font size="2" face="Verdana"><img title="application management" alt="application management" src="https://www.dotnetcurry.com/images/sharepoint/applicationmanagement0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">This will open a Create site Page. From that page, choose a web application under which you want to create a site collection. Once you choose a Web Application, give the title to your site collection and choose a URL. Optionally you can write a site description as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="site description" alt="site description" src="https://www.dotnetcurry.com/images/sharepoint/sitedescription0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Now select a site template from Enterprise Group as shown below: </font></p> <p align="justify"><font size="2" face="Verdana"><img title="business intelligence center template" alt="business intelligence center template" src="https://www.dotnetcurry.com/images/sharepoint/businessintelligencecentertemplate0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">And at the end, provide your site collection administrator primary account with ‘<b>Domain\Administrator</b>’ , check the domain account and click OK as shown below: </font></p> <p align="justify"><font size="2" face="Verdana"><img title="site collection administrator" alt="site collection administrator" src="https://www.dotnetcurry.com/images/sharepoint/sitecollectionadministrator0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">This will create a site collection as shown below: </font></p> <p align="justify"><font size="2" face="Verdana"><img title="site collection" alt="site collection" src="https://www.dotnetcurry.com/images/sharepoint/sitecollection0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Now click on the link and you will see your Business Intelligence center site as shown below :</font></p> <p align="justify"><font size="2" face="Verdana"><img title="business intelligence center site" alt="business intelligence center site" src="https://www.dotnetcurry.com/images/sharepoint/businessintelligencecentersite0211.png" /></font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 2 :</b> Once your site is ready, browse the site and hover your mouse on the ‘Create Dashboard’ in right hand section. You will see the links as shown below – </font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="create dashboard" alt="create dashboard" src="https://www.dotnetcurry.com/images/sharepoint/createdashboard0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Click on the link ‘<b>Start using PerformancePoint Services</b>’. This link will take you to a page where you can download a Dashboard Designer Tool by clicking a button ‘<b>Run Dashboard Designer</b>’ as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="run dashboard designer" alt="run dashboard designer" src="https://www.dotnetcurry.com/images/sharepoint/rundashboarddesigner0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">This will download a Dashboard Designer tool at your client side. This is a Click Once Application. This tool now will help you to design the Data Sources, KPIs, Scorecards, Reports, Filters and Dashboards. The tool looks sishown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="dashboard designer tool" alt="dashboard designer tool" src="https://www.dotnetcurry.com/images/sharepoint/dashboarddesignertool0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">In the left hand section, you will see <i>Workspace Browser</i>. In this window, you will see the following – </font></p> <p align="justify"><font size="2" face="Verdana">1) Data Connections -</font></p> <blockquote style="MARGIN-RIGHT: 0px" dir="ltr"> <p align="justify"><font size="2" face="Verdana">a. It is used for creating a connection with different types of data sources as shown below</font></p> <p align="justify"><font size="2" face="Verdana"><img title="data connections" alt="data connections" src="https://www.dotnetcurry.com/images/sharepoint/dataconnections0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">b. For our demonstration, we are going to use a multidimensional Data Source that is <em>Analysis Services</em>. </font></p> </blockquote> <p align="justify"><font size="2" face="Verdana">2) PerformancePoint Content – </font></p> <blockquote style="MARGIN-RIGHT: 0px" dir="ltr"> <p align="justify"><font size="2" face="Verdana">a. Using PerformancePoint Content, we can design KPIs, Filters, Reports, Dashboards, Indicators and Scorecards as shown below</font></p> <p align="justify"><font size="2" face="Verdana"><img title="performance point content" alt="performance point content" src="https://www.dotnetcurry.com/images/sharepoint/performancepointcontent0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">b. For our demonstration, we are going to design Scorecard, KPIs, Reports and Dashboard.</font></p> </blockquote> <p align="justify"><font face="Verdana"><font size="2"><b>Step 3:</b> For this demonstration, I am using a Pro-clarity Data warehouse database which is a demo database provided by Microsoft. This database was given by Microsoft when PerformancePoint Server 2007 was released in year 2007.</font></font></p> <p align="justify"><font size="2" face="Verdana">You can </font><a href="http://blogs.msdn.com/b/performancepoint/archive/2008/01/03/error-restoring-pdw-sample-data-cube-in-2008.aspx" target="_blank"><font size="2" face="Verdana">download this database from here</font></a></p> <p align="justify"><font size="2" face="Verdana">Restore the backup of the database with your SQL Server Analysis Services. Now let’s create a data connection for our PDW (Pro-clarity Data warehouse) database in our Dashboard Designer tool.</font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 4:</b> Right click ‘Data Connections’ > Click on ‘New Data Source’ as shown below: </font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="data connections new source" alt="data connections new source" src="https://www.dotnetcurry.com/images/sharepoint/dataconnectionsnewsource0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">From ‘Select a Data Source Template’ window, make a choice of ‘Analysis Services’ and configure your PDW database as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="pdw database" alt="pdw database" src="https://www.dotnetcurry.com/images/sharepoint/pdwdatabase0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Once you configure the connection to your Analysis Services and Database PDW, choose a cube ‘Sales’ and then click the ‘<b>Test Data Source</b>’ button. You should see a Connection Successful window.</font></p> <p align="justify"><font size="2" face="Verdana">Now rename the data source by ‘<b>PDW</b>’ and save it.</font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 5:</b> Now we are ready with our Analysis Services Data Source. Let’s create a Scorecard which will hold our KPIs as shown below :</font></font></p> <p align="justify"><font size="2" face="Verdana">KPIs to be created – </font></p> <p align="justify"><font size="2" face="Verdana">1) Sales Amount.</font></p> <p align="justify"><font size="2" face="Verdana">2) Days Late.</font></p> <p align="justify"><font size="2" face="Verdana">3) Gross Profit %.</font></p> <p align="justify"><font size="2" face="Verdana">Right click on ‘PerformancePoint Content’ > New > Scorecard as shown below: </font></p> <p align="justify"><font size="2" face="Verdana"><img title="performancepoint content score card" alt="performancepoint content score card" src="https://www.dotnetcurry.com/images/sharepoint/performancepointcontentscorecard0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">This will show a dialog box to select a template for a Scorecard, as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="scorecard template" alt="scorecard template" src="https://www.dotnetcurry.com/images/sharepoint/scorecardtemplate0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Make sure you select the Analysis Services template from Microsoft for our scorecard. We will use a Wizard option for our scorecard. This wizard will guide us to select a data source. The next step is to add a new KPI in our scorecard or select the existing KPIs from our data source (in case you have any). The steps are shown below :</font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 6:</b> First select the PDW data source which we have created in our previous steps:</font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="analysis services scorecard" alt="analysis services scorecard" src="https://www.dotnetcurry.com/images/sharepoint/analysisservicesscorecard0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Once you select the data source, click the Next button in the wizard. This will take you to a step where we can either import existing KPIs from our data source or we can create new KPIs. Choose ‘<b>Create new KPIs from SQL Server Analysis Services Measures’</b> and click the Next button.</font></p> <p align="justify"><font size="2" face="Verdana">Now let’s add the three KPIs which we have listed above:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="kpis" alt="kpis" src="https://www.dotnetcurry.com/images/sharepoint/kpis0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Your KPIs should look similar to the one shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="imported kpis" alt="imported kpis" src="https://www.dotnetcurry.com/images/sharepoint/importedkpis0211.png" /></font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 7:</b> Now click Next button until you reach the Finish wizard button. Keep all the default settings. Rename your Scorecard as ‘<b>PDW Demo Scorecard</b>’. You are now done with a basic scorecard with three KPIs. It should look like the one shown below:</font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="pdw demo scorecard" alt="pdw demo scorecard" src="https://www.dotnetcurry.com/images/sharepoint/pdwdemoscorecard0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Now let’s modify the scorecard by adding our Products and timeline. You will see a <b>‘Details’</b> window on your right hand side screen, as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="details window" alt="details window" src="https://www.dotnetcurry.com/images/sharepoint/detailswindow0211.png" /></font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 8:</b> Now expand the <i>Dimensions </i>node. You will see <i>Product</i>. From Product, drag and drop <i>Family</i> to Sales Amount, Days Late and Gross Profit % , as shown below:</font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="scorecard dimensions" alt="scorecard dimensions" src="https://www.dotnetcurry.com/images/sharepoint/scorecarddimensions0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Once you drop a <i>Product</i> Family, you will get a popup window to choose your products. Make a choice of your products as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="select members" alt="select members" src="https://www.dotnetcurry.com/images/sharepoint/selectmembers0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Click OK. Now go to Edit Ribbon and click on the ‘Update’ button and your scorecard will display the data as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="edit ribbon update" alt="edit ribbon update" src="https://www.dotnetcurry.com/images/sharepoint/editribbonupdate0211.png" /></font></p> <p align="justify"><font face="Verdana"><font size="2"><b>Step 9:</b> Now let’s expand the <i>Time</i> node from <i>Dimensions</i> and select a <i>Quarter</i>. Drag and drop this on top of <i>Actual </i>and <i>Target</i> and make a choice of a specific time (say Q1-06, Q2-06) respectively as shown below:</font></font></p> <p align="justify"><font size="2" face="Verdana"><img title="actual target dimensions" alt="actual target dimensions" src="https://www.dotnetcurry.com/images/sharepoint/actualtargetdimensions0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">Once you have dragged and dropped the <i>Time</i> dimension, go to Edit ribbon and click on the ‘Update’ button and your scorecard will look as shown below:</font></p> <p align="justify"><font size="2" face="Verdana"><img title="pdw demo scorecard with kpi dashboard" alt="pdw demo scorecard with kpi dashboard" src="https://www.dotnetcurry.com/images/sharepoint/pdwdemoscorecardwithkpidashboard0211.png" /></font></p> <p align="justify"><font size="2" face="Verdana">That’s all. Your scorecard is ready.</font></p> <p align="justify"><b><font size="2" face="Verdana">Conclusion</font></b></p> <p align="justify"><font size="2" face="Verdana">In this article, we have seen how to create a SharePoint site, KPIs and a Scorecard using PerformancePoint Services Dashboard Designer Tool. For this demonstration we have used Microsoft Multidimensional Data Source that is SQL Server Analysis Services Database. In the second part, we will extend this example and see how to create a Chart report and Grid Report using SQL Server Analysis Services (SSAS) Data Source. </font></p> <p align="justify"><font size="2" face="Verdana"><strong><font size="3">Update:</font></strong> Part 2 of this article - <a href="https://www.dotnetcurry.com/ShowArticle.aspx?ID=654">Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 2</a> </font></p> <p><em>This article has been editorially reviewed by </em><a href="https://www.dotnetcurry.com/author/suprotim-agarwal"><em>Suprotim Agarwal.</em></a></p> <div id="csharpbook" class="col-xs-12 col-sm-12 col-md-12 col-lg-12 articletext">  <div class="col-md-3 col-sm-3 col-xs-12"> <a href="https://www.dotnetcurry.com/csharpbook" target="_blank"><img alt="Absolutely Awesome Book on C# and .NET" src="/csharpbook/images/csharp-book-ad.jpg" /></a> </div> <div class="col-md-9 col-sm-9 col-xs-12"> <p>C# and .NET have been around for a very long time, but their constant growth means there’s always more to learn.</p> <p>We at DotNetCurry are very excited to announce <strong><a href="https://www.dotnetcurry.com/csharpbook" target="_blank">The Absolutely Awesome Book on C# and .NET</a></strong>. This is a 500 pages concise technical eBook available in PDF, ePub (iPad), and Mobi (Kindle). </p><p>Organized around concepts, this Book aims to provide a concise, yet solid foundation in C# and .NET, covering <b>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</b>. 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.</p> <p><strong><a href="https://www.dotnetcurry.com/csharpbook" target="_blank" style="color:#cd282f">Click here to Explore the Table of Contents or Download Sample Chapters!<a /></strong></p> </div> </div> <div class="footerheading margin-top-20">What Others Are Reading!</div> <div class="col-xs-12 col-sm-12 col-md-12 similarauthor"> <div class="row"> <div class="col-md-12 similararticles"> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1184" style="color:#4A75AD;font-weight:normal;">High-Trust Apps in SharePoint - Digging Deeper</a> <br /><br /> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1141" style="color:#4A75AD;font-weight:normal;">Production Ready SharePoint Applications with Little or No Code</a> <br /><br /> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1132" style="color:#4A75AD;font-weight:normal;">Discovering High-Trust SharePoint Apps</a> <br /><br /> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1121" style="color:#4A75AD;font-weight:normal;">Developing SharePoint 2013 Apps using Angular.js</a> <br /><br /> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1113" style="color:#4A75AD;font-weight:normal;">Creating an App Scoped External Content Type (ECT) in SharePoint using OData Services and BCS</a> <br /><br /> <a href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1070" style="color:#4A75AD;font-weight:normal;">Why would I use SharePoint as a Content Management System (CMS)?</a> <br /><br /> <span id="ctl00_MainContent_SimilarPosts1_lblCategoNam"></span> </div> </div> </div>  <div class="visible-xs visible-sm visible-md visible-lg"> <div id='dnc-bot-txtad' class="articletext"> </div> </div> <div class="socialbox"> <b>Was this article worth reading? Share it with fellow developers too. Thanks!</b> <br/>  <a class="resp-sharing-button__link" id="fbsharelink" target="_blank" aria-label="Share on Facebook"> <div class="resp-sharing-button resp-sharing-button--facebook resp-sharing-button--large"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg version="1.1" x="0px" y="0px" width="24px" height="24px" viewBox="0 0 24 24" enable-background="new 0 0 24 24" xml:space="preserve"> <g> <path d="M18.768,7.465H14.5V5.56c0-0.896,0.594-1.105,1.012-1.105s2.988,0,2.988,0V0.513L14.171,0.5C10.244,0.5,9.5,3.438,9.5,5.32 v2.145h-3v4h3c0,5.212,0,12,0,12h5c0,0,0-6.85,0-12h3.851L18.768,7.465z"/> </g> </svg> </div>Share on Facebook</div> </a>  <a class="resp-sharing-button__link" id="twtsharelink" target="_blank" aria-label="Share on Twitter"> <div class="resp-sharing-button resp-sharing-button--twitter resp-sharing-button--large"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg version="1.1" x="0px" y="0px" width="24px" height="24px" viewBox="0 0 24 24" enable-background="new 0 0 24 24" xml:space="preserve"> <g> <path d="M23.444,4.834c-0.814,0.363-1.5,0.375-2.228,0.016c0.938-0.562,0.981-0.957,1.32-2.019c-0.878,0.521-1.851,0.9-2.886,1.104 C18.823,3.053,17.642,2.5,16.335,2.5c-2.51,0-4.544,2.036-4.544,4.544c0,0.356,0.04,0.703,0.117,1.036 C8.132,7.891,4.783,6.082,2.542,3.332C2.151,4.003,1.927,4.784,1.927,5.617c0,1.577,0.803,2.967,2.021,3.782 C3.203,9.375,2.503,9.171,1.891,8.831C1.89,8.85,1.89,8.868,1.89,8.888c0,2.202,1.566,4.038,3.646,4.456 c-0.666,0.181-1.368,0.209-2.053,0.079c0.579,1.804,2.257,3.118,4.245,3.155C5.783,18.102,3.372,18.737,1,18.459 C3.012,19.748,5.399,20.5,7.966,20.5c8.358,0,12.928-6.924,12.928-12.929c0-0.198-0.003-0.393-0.012-0.588 C21.769,6.343,22.835,5.746,23.444,4.834z"/> </g> </svg> </div>Share on Twitter</div> </a>  <a class="resp-sharing-button__link" id="linkdinsharelink" target="_blank" aria-label="Share on LinkedIn"> <div class="resp-sharing-button resp-sharing-button--linkedin resp-sharing-button--large"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg xmlns="https://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M6.5 21.5h-5v-13h5v13zM4 6.5C2.5 6.5 1.5 5.3 1.5 4s1-2.4 2.5-2.4c1.6 0 2.5 1 2.6 2.5 0 1.4-1 2.5-2.6 2.5zm11.5 6c-1 0-2 1-2 2v7h-5v-13h5V10s1.6-1.5 4-1.5c3 0 5 2.2 5 6.3v6.7h-5v-7c0-1-1-2-2-2z"/></svg> </div>Share on LinkedIn</div> </a>  <a class="resp-sharing-button__link" id="googsharelink" target="_blank" aria-label="Share on Google+"> <div class="resp-sharing-button resp-sharing-button--google resp-sharing-button--large"><div aria-hidden="true" class="resp-sharing-button__icon resp-sharing-button__icon--solid"> <svg version="1.1" x="0px" y="0px" width="24px" height="24px" viewBox="0 0 24 24" enable-background="new 0 0 24 24" xml:space="preserve"> <g> <path d="M11.366,12.928c-0.729-0.516-1.393-1.273-1.404-1.505c0-0.425,0.038-0.627,0.988-1.368 c1.229-0.962,1.906-2.228,1.906-3.564c0-1.212-0.37-2.289-1.001-3.044h0.488c0.102,0,0.2-0.033,0.282-0.091l1.364-0.989 c0.169-0.121,0.24-0.338,0.176-0.536C14.102,1.635,13.918,1.5,13.709,1.5H7.608c-0.667,0-1.345,0.118-2.011,0.347 c-2.225,0.766-3.778,2.66-3.778,4.605c0,2.755,2.134,4.845,4.987,4.91c-0.056,0.22-0.084,0.434-0.084,0.645 c0,0.425,0.108,0.827,0.33,1.216c-0.026,0-0.051,0-0.079,0c-2.72,0-5.175,1.334-6.107,3.32C0.623,17.06,0.5,17.582,0.5,18.098 c0,0.501,0.129,0.984,0.382,1.438c0.585,1.046,1.843,1.861,3.544,2.289c0.877,0.223,1.82,0.335,2.8,0.335 c0.88,0,1.718-0.114,2.494-0.338c2.419-0.702,3.981-2.482,3.981-4.538C13.701,15.312,13.068,14.132,11.366,12.928z M3.66,17.443 c0-1.435,1.823-2.693,3.899-2.693h0.057c0.451,0.005,0.892,0.072,1.309,0.2c0.142,0.098,0.28,0.192,0.412,0.282 c0.962,0.656,1.597,1.088,1.774,1.783c0.041,0.175,0.063,0.35,0.063,0.519c0,1.787-1.333,2.693-3.961,2.693 C5.221,20.225,3.66,19.002,3.66,17.443z M5.551,3.89c0.324-0.371,0.75-0.566,1.227-0.566l0.055,0 c1.349,0.041,2.639,1.543,2.876,3.349c0.133,1.013-0.092,1.964-0.601,2.544C8.782,9.589,8.363,9.783,7.866,9.783H7.865H7.844 c-1.321-0.04-2.639-1.6-2.875-3.405C4.836,5.37,5.049,4.462,5.551,3.89z"/> <polygon points="23.5,9.5 20.5,9.5 20.5,6.5 18.5,6.5 18.5,9.5 15.5,9.5 15.5,11.5 18.5,11.5 18.5,14.5 20.5,14.5 20.5,11.5 23.5,11.5 "/> </g> </svg> </div>Share on Google+</div> </a>  </div> <br /> <div class="col-xs-12 col-sm-12 col-md-12 similarauthor"> <div class="row footerheading">Author</div> <div class="row"> <div class="col-md-12"> <div class="col-md-12 author-wrap img-rounded"> <div class="author-image thumbnail"> <img id="ctl00_MainContent_authorInfo_imgAuthor" onerror="this.onload = null; this.src='/images/authors/NoImage.jpg';" src="images/authors/Pravinkumar%20Dabade.jpg" style="border-width:0px;" /> </div> <div class="author-desc caption"> 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 </div> </div> </div> </div> </div> </div>  <div class="marginspace"> <div id='ban-pos-9-90'></div> <div id='ban-pos-10-90'></div> <div id='ban-pos-11-90'></div> </div> <br /><br /> <div class="col-xs-12 col-sm-12 col-md-12"> <img src="/images/copyscape.gif" alt="Page copy protected against web site content infringement by Copyscape" title="Do not copy content from the page. Plagiarism will be detected by Copyscape." height="16" border="0"/> </div> <br /><br /> <br /> <hr /> <div id="ctl00_MainContent_panComments" class="col-md-12 spacer"> <div class="footerheading">Feedback - Leave us some adulation, criticism and everything in between!</div> <ul class="tabHeader"> <li><a class="show-comments" href="#t1">Click here to post your Comments</a> </li> <li><a href="#t2">Old Comments (Read Only)</a> </li> </ul> <div class="tabContent"> <div id="t1" class="col-md-12 column"> <div id="disqus_thread"></div>  </div> <div id="t2"> <table id="ctl00_MainContent_dlstComments" class="table col-xs-4 col-sm-6 col-md-12" cellspacing="0" border="0" style="color:#333333;border-collapse:collapse;"> <tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl00_lnkAddedBy" style="color:#6592C6;">Syed</span> on Saturday, February 12, 2011 1:41 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hello Pravin, <br> <br>  i wanted to know how do i create a connection with other data sources like Oracle 11G. Kindly Suggest. i'll wait for your reply. <br> <br>thank you for any reply. <br>Syed. </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl01_lnkAddedBy" style="color:#6592C6;">Pravinkumar</span> on Saturday, February 12, 2011 1:54 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Syed, <br> <br>You can not create a connection directly to Oracle. However, There are two ways of doing this. <br>1) You can use SQL Server Integration Services and get Oracle data into SQL Server. Then you can get connected with SQL Server Data Source. <br>2) you can create a Business Connectivity Service App and then you can take the Data from SharePoint List. This link may be helpful for you. <br> <br>http://technet.microsoft.com/en-us/library/gg247614.aspx <br> <br>Pravin </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl02_lnkAddedBy" style="color:#6592C6;">Wesley</span> on Saturday, February 12, 2011 6:42 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Good article. I enjoyed reading it over a cup of coffee :) </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl03_lnkAddedBy" style="color:#6592C6;">Manish</span> on Monday, February 14, 2011 3:04 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Very nice way of explanation, Keep it up Pravin. </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl04_lnkAddedBy" style="color:#6592C6;">Ranjani</span> on Wednesday, April 6, 2011 8:07 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> hi, <br> <br>I created KPI using the sql server datasource . i want to know how to incorporate in scorecard and dashboard. my requirement is if a sql column is equal to another sql column then green indicator should be shown or else red if source is greater than target. </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl05_lnkAddedBy" style="color:#6592C6;">Ravi</span> on Friday, April 8, 2011 5:38 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Pravin, <br> <br>Very good article. I have a Score Card created using SQL Server. The Aggregation column in data source is always creating KPI for only one row (either max, min,count, sum, statistical etc) but i want to compare each and every row of the sql (that is all 10 -15 rows available in the table ). Can you please let me know how this can be achieved. <br> <br>thanks in advance <br> </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl06_lnkAddedBy" style="color:#6592C6;">rasul</span> on Friday, November 4, 2011 7:24 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> hi, <br>while doing BI am getting error while connecting to datasource that This datasource cannot be used because peformance point services is not configured correctly.Additional details have been logged for your administrator. please send me the solution where i did mistake. </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl07_lnkAddedBy" style="color:#6592C6;">Wilson Fernandes</span> on Sunday, December 11, 2011 9:49 PM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Pravin, It is with reference to the Excel Services - Excel 2010 the Pivot features - what are the areas that are used in PPS? </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl08_lnkAddedBy" style="color:#6592C6;">Mikhail</span> on Friday, March 2, 2012 6:44 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Would like to recommend HarePoint Analytics for SharePoint: the essential web-analytics solution for SharePoint-based sites and portals. More 70 reports, wide customization, great features. <br>Homepage: http://www.harepoint.com/Products/HarePointAnalyticsForSharePoint/Default.aspx </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl09_lnkAddedBy" style="color:#6592C6;">SafeStick</span> on Thursday, March 22, 2012 6:13 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Parvin, <br> How do you change row width in dashboard because i cant see my full data in dashboard frontend . <br>Thanx in advance </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl10_lnkAddedBy" style="color:#6592C6;">SafeStick</span> on Thursday, March 22, 2012 6:22 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Parvin, <br> How do you change row width in dashboard because i cant see my full data in dashboard frontend . <br>Thanx in advance </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl11_lnkAddedBy" style="color:#6592C6;">Manet</span> on Saturday, May 26, 2012 4:53 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Pravin, can you run analysis services referring to an excel sheet? I was tying to get the KPI's and  charts side by side with my data source from excel. </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl12_lnkAddedBy" style="color:#6592C6;">gurdeep kaur</span> on Monday, August 6, 2012 4:32 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> If i creates a dashboard by selecting option for design as 2 Rows which gives me as Top Row and Bottom Row for the new page in Dashboard <br>why we are unable to chnage the width for top row </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl13_lnkAddedBy" style="color:#6592C6;">Gurdeep Kaur</span> on Monday, August 6, 2012 4:33 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Please reply of my above question as i am facing issues </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl14_lnkAddedBy" style="color:#6592C6;">Gurdeep Kaur</span> on Monday, August 6, 2012 6:19 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Please reply of my above question as i am facing issues </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl15_lnkAddedBy" style="color:#6592C6;">Gurdeep Kaur</span> on Monday, August 6, 2012 11:11 PM </b> </td> <td style="text-align: right;"> </td></tr> </table> Please reply of my above question as i am facing issues </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl16_lnkAddedBy" style="color:#6592C6;">can i create chart using sharepoint list</span> on Thursday, August 23, 2012 11:46 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Can i create chart by using sharepoint list as datasource? </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl17_lnkAddedBy" style="color:#6592C6;">Suja </span> on Friday, February 8, 2013 10:27 PM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Pravin, Thanks a lot for this great article. I am basically a SharePoint developer. I have all data stored in SharePoint List. How can I create reports/dashboards using the data from different lists? <br> </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl18_lnkAddedBy" style="color:#6592C6;">hung</span> on Wednesday, March 20, 2013 5:46 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> hi, i got error: <br> <br>An error has occured attempting to contact the specified SharePoint site.  Please check your connection and settings and try again. <br> <br>can you help me </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl19_lnkAddedBy" style="color:#6592C6;">Durga Ramesh</span> on Saturday, December 7, 2013 5:25 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi Pravin, <br> <br>Very good article. I have a Score Card created using SQL Server. The Aggregation column in data source is always creating KPI for only one row (either max, min,count, sum, statistical etc) but i want to compare each and every row of the sql (that is all 10 -15 rows available in the table ). Can you please let me know how this can be achieved. <br> <br>thanks in advance </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl20_lnkAddedBy" style="color:#6592C6;">Neena</span> on Sunday, February 2, 2014 12:32 PM </b> </td> <td style="text-align: right;"> </td></tr> </table> Great effort </div> </td> </tr><tr> <td style="color:#333333;background-color:White;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl21_lnkAddedBy" style="color:#6592C6;">Rajanikanth</span> on Friday, February 21, 2014 12:09 AM </b> </td> <td style="text-align: right;"> </td></tr> </table> Nice article.. <br> <br>IN SP performance Point services, I am only able select the datasource at first on report creation. how to change  report datasource. </div> </td> </tr><tr> <td style="color:#333333;background-color:#EFEFE3;"> <div> <table class="table"> <tr><td class="row"> <b>Comment posted by <span id="ctl00_MainContent_dlstComments_ctl22_lnkAddedBy" style="color:#6592C6;">Gaurav</span> on Tuesday, July 29, 2014 4:59 PM </b> </td> <td style="text-align: right;"> </td></tr> </table> Hi, <br>I have created dashboard from sql server view using designer. It is deployed to sharepoint, however when we refresh the page, it shows junk values for all the rows and columns. It happens most of the time, and sometimes it shows the correct values and indicators. Can you suggest what could be reason for those junk values?? Thanks! <br> </div> </td> </tr><tr> <td style="color:White;background-color:#990000;font-weight:bold;"> </td> </tr> </table> </div>  </div>  </div>   </div> <div id="rightcol" class="col-md-4">  <div class="margin-vertical-20" /> <div class="side-widget"> <div class="featured-tools"> <span>Featured Tools</span> <div id="creatives"> <div id='ban-pos-1' style='display: none'> </div> <div id='ban-pos-2'> <div class="padding-vertical-10"></div> </div> <div id='ban-pos-3'> </div> <div class="padding-vertical-10"></div> <div id='ban-pos-4-250'> </div> <div id='ban-pos-5-250'> </div> <div id='ban-pos-6-250'> </div> </div> </div> </div> <div class="sec-title"> <h4>Categories</h4> </div> <div class="side-widget"> <ul id="toggle-view"> <li> <h3>.NET Web</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/aspnet">ASP.NET</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-mvc">ASP.NET MVC</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/aspnet-core">ASP.NET Core</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-ajax">ASP.NET AJAX</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/sharepoint">SharePoint</a> <a href="https://www.dotnetcurry.com/tutorials/wcf">WCF</a> </div> </div> </li> <li> <h3>.NET Framework, Visual Studio and C#</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/csharp">C#</a> <a href="https://www.dotnetcurry.com/tutorials/linq">LINQ</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/visualstudio">Visual Studio</a> <a href="https://www.dotnetcurry.com/tutorials/vsts-tfs">VSTS & TFS</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/entityframework">Entity Framework</a> <a href="https://www.dotnetcurry.com/tutorials/dotnetframework">.NET Framework</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/dotnet-standard-core">.NET Standard & .NET Core</a> </div> </div> </li> <li> <h3>Patterns & Practices</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/patterns-practices">Design Patterns</a> <a href="https://www.dotnetcurry.com/tutorials/software-gardening">Software Gardening</a> </div> </div> </li> <li> <h3>Cloud and Mobile</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/windows-azure">Microsoft Azure</a> <a href="https://www.dotnetcurry.com/tutorials/xamarin">Xamarin</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/powershell">Powershell</a> <a href="https://www.dotnetcurry.com/tutorials/machine-learning-ai">Machine Learning & AI</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/windows-store">UWP & Windows Store</a> <a href="https://www.dotnetcurry.com/tutorials/windowsphone">Windows Phone</a> </div> </div> </li> <li> <h3>JavaScript</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/typescript">TypeScript</a> <a href="https://www.dotnetcurry.com/tutorials/angularjs">Angular</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/jquery-aspnet">jQuery</a> <a href="https://www.dotnetcurry.com/tutorials/nodejs">Node.js</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/reactjs">React.js</a> <a href="https://www.dotnetcurry.com/tutorials/backbonejs">Backbone.js</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/html5-javascript">HTML5 & JavaScript</a> <a href="https://www.dotnetcurry.com/tutorials/bootstrap-css">Bootstrap & CSS</a> </div> </div> </li> <li> <h3>.NET Desktop</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/wpf">WPF</a> <a href="https://www.dotnetcurry.com/tutorials/winforms">WinForms</a> </div> </div> </li> <li> <h3>Interview Questions & Product Reviews</h3> <span class="fa fa-angle-down"></span> <div class="toggle-panel"> <div> <a href="https://www.dotnetcurry.com/tutorials/dotnetinterview">.NET Interview Q&A</a> <a href="https://www.dotnetcurry.com/tutorials/product-articles-review">Product Reviews</a> </div> <div> <a href="https://www.dotnetcurry.com/tutorials/general-programming-topics">General Topics</a> </div> </div> </li> </ul> </div> <div class="sec-title"> <h3><b>JOIN OUR COMMUNITY</b></h3> </div> <div class="side-widget"> <div class="side-social"> <a href="https://www.facebook.com/dotnetcurry"><i class="fa fa-facebook"></i> 50K+ <span>fans</span></a> <a href="https://www.twitter.com/dotnetcurry"><i class="fa fa-twitter"></i> 8K+ <span>followers</span></a> <a href="https://www.dotnetcurry.com/magazine/"><i class="fa fa-envelope"></i> 128K+ <span>subscribers</span></a> </div> </div> <div class="sec-title"> <h3><b>POPULAR ARTICLES</b></h3> </div> <div id="latestart" class="side-widget"> <div> <a id="ctl00_toplat_Repeater1_ctl00_lnkTitle" class="top" href="http://www.dotnetcurry.com/ShowArticle.aspx?ID=1608" style="color:#4A75AD;font-weight:normal;">What's New for ASP.NET Core & Blazor in .NET 9</a> <br /> <br /> <br /> </div> </div> <div id='ban-pos-7-600'> </div> <div id='ban-pos-8-600'> </div> <div class="sec-title-plain"> <h4>Tags</h4> </div> <div class="side-widget"> <div class="tags"> <a href="https://www.dotnetcurry.com/tutorials/aspnet-mvc">ASP.NET MVC</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet-core">ASP.NET Core</a> <a href="https://www.dotnetcurry.com/tutorials/aspnet">ASP.NET</a> <a href="https://www.dotnetcurry.com/tutorials/sharepoint">SharePoint</a> <a href="https://www.dotnetcurry.com/tutorials/patterns-practices">Design Patterns</a> <a href="https://www.dotnetcurry.com/tutorials/csharp">C#</a> <a href="https://www.dotnetcurry.com/tutorials/linq">LINQ</a> <a href="https://www.dotnetcurry.com/tutorials/wpf">WPF</a> <a href="https://www.dotnetcurry.com/tutorials/wcf">WCF</a> <a href="https://www.dotnetcurry.com/tutorials/visualstudio">Visual Studio</a> <a href="https://www.dotnetcurry.com/tutorials/vsts-tfs">VSTS & TFS</a> <a href="https://www.dotnetcurry.com/tutorials/windows-azure">Azure</a> <a href="https://www.dotnetcurry.com/tutorials/entityframework">Entity Framework</a> <a href="https://www.dotnetcurry.com/tutorials/angularjs">Angular.js</a> <a href="https://www.dotnetcurry.com/tutorials/reactjs">React.js</a> <a href="https://www.dotnetcurry.com/tutorials/jquery-aspnet">jQuery</a> <a href="https://www.dotnetcurry.com/tutorials/html5-javascript">JavaScript</a> <a href="https://www.dotnetcurry.com/tutorials/html5-javascript">HTML5</a> <a href="https://www.dotnetcurry.com/tutorials/dotnet-standard-core">.NET Core</a> <a href="https://www.dotnetcurry.com/tutorials/dotnetframework">.NET Framework</a> </div> </div> <div class="sec-title"> <h3><b>JQUERY COOKBOOK</b></h3> </div> <div class="side-widget"> <a href="http://www.jquerycookbook.com"><img src="https://www.dotnetcurry.com/images/books/300x300-jqckbk.png" alt="jQuery CookBook" /></a> </div> </div> </div> </div>  </div>  <footer class="margin-top-30"> <div class="container"> <div class="footer-head"> <div class="row center-content"> <div class="col-md-2 col-sm-3"> <a href="https://www.dotnetcurry.com"> <img data-src="/img/dnc-logo-tee-trans.png" class="img-responsive lazyload" alt="" /> </a> </div> <div class="col-md-6 col-sm-4"> <p></p> </div>  </div> </div> <div class="footer-content"> <div class="row"> <div class="col-sm-2"> <h5 class="text-white">Server-Side</h5> <ul class="footer-links"> <li><a href="https://www.dotnetcurry.com/tutorials/aspnet">ASP.NET</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/aspnet-core">ASP.NET Core</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/aspnet-mvc">ASP.NET MVC</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/wcf">WCF</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/sharepoint">SharePoint</a></li> </ul> </div> <div class="col-sm-2"> <h5 class="text-white">Client-side</h5> <ul class="footer-links"> <li><a href="https://www.dotnetcurry.com/tutorials/angularjs">Angular.js</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/reactjs">React.js</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/jquery-aspnet">jQuery</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/backbonejs">Backbone.js</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/html5-javascript">HTML5</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/bootstrap-css">CSS</a></li> </ul> </div> <div class="col-sm-2"> <h5 class="text-white">.NET</h5> <ul class="footer-links"> <li><a href="https://www.dotnetcurry.com/tutorials/csharp">C#</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/visualstudio">Visual Studio</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/vsts-tfs">VSTS & TFS</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/linq">LINQ</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/entityframework">Entity Framework</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/dotnetframework">.NET Framework</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/dotnet-standard-core">.NET Standard & .NET Core</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/wpf">WPF</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/winforms">WinForms</a></li> </ul> </div> <div class="col-sm-2"> <h5 class="text-white">Cloud and Mobile</h5> <ul class="footer-links"> <li><a href="https://www.dotnetcurry.com/tutorials/windows-azure">Microsoft Azure</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/devops">DevOps</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/xamarin">Xamarin</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/powershell">Powershell</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/machine-learning-ai">Machine Learning & AI</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/windows-store">UWP & Windows Store</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/windowsphone">Windows Phone</a></li> </ul> </div> <div class="col-sm-2"> <h5 class="text-white">Skill Up</h5> <ul class="footer-links"> <li><a href="https://www.dotnetcurry.com/tutorials/patterns-practices">Design Patterns</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/software-gardening">Software Gardening</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/dotnetinterview">.NET Interview Q&A</a></li> <li><a href="https://www.dotnetcurry.com/magazine/" class="last">Magazines</a></li> <li><a href="http://www.jquerycookbook.com/">Books</a></li> <li><a href="https://www.dotnetcurry.com/tutorials/product-articles-review">Product Reviews</a></li> </ul> </div> <div class="col-sm-2"> <h5 class="text-white">Follow Us</h5> <ul class="footer-social"> <li><a href="https://www.facebook.com/dotnetcurry">Facebook</a></li> <li><a href="https://www.twitter.com/dotnetcurry">Twitter</a></li> <li><a href="https://github.com/dotnetcurry">Github</a></li> </ul> </div> </div> </div> <div class="footer-bottom"> <div class="row"> <div class="col-sm-6"> <p>© 2007-2023 DotNetCurry.com (A subsidiary of A2Z Knowledge Visuals Pvt. Ltd). All rights reserved.</p> </div> <div class="col-sm-6 text-right"> <ul class="list-inline"> <li><a href="https://www.dotnetcurry.com/Contact.aspx">Contact Us</a></li> <li><a href="https://www.dotnetcurry.com/WriteForUs.aspx">Write For Us</a></li> <li><a href="https://www.dotnetcurry.com/PrivacyPolicy.aspx">Privacy</a></li> <li><a href="https://www.dotnetcurry.com/terms-conditions">Terms</a></li> </ul> </div> </div> </div> </div> </footer>  </form> <script src="//ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script src="//js.maxmind.com/js/apis/geoip2/v2.1/geoip2.js"></script> <script src="/bundles/scriptsmin?v=ztXW8lGCJchjv7iQbaTOZjTpSGfOrLg1lKllrWansXI1"></script> <script src="/bundles/framework?v=yOkBizHgoWwNt4OFd4FauUxu9fucEJ_a4EJrci8uIGA1"></script> <script type="text/javascript"> SyntaxHighlighter.defaults['auto-links'] = false; SyntaxHighlighter.defaults['gutter'] = false; SyntaxHighlighter.defaults['toolbar'] = false; SyntaxHighlighter.all() </script> <script> $(function () { $('.tabHeader').children().first().addClass('current'); $('.tabContent').children().first().addClass('current'); $('.tabHeader li').click(function (e) { e.preventDefault(); $(this).siblings('.current').removeClass('current'); $(this).addClass('current'); $('.tabContent').children('.current').removeClass('current'); $('.tabContent').children().eq($(this).index()).addClass('current'); }); }); </script> <script src="https://ajax.googleapis.com/ajax/libs/webfont/1.5.18/webfont.js"></script> <script> WebFont.load({ google: { families: ['Hind Vadodara:300,400,500,600,700'] } }); </script> </body> </html>

CINXE.COM

Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 1 | DotNetCurry