PerformancePoint Services Resource Center | Developer | MSDN. Roger Doherty's SQL Server Evangelism Blog. 47 minutes, 18 seconds 39 minutes, 9 seconds 5 minutes, 18 seconds 10 minutes, 57 seconds 14 minutes, 48 seconds 6 minutes, 31 seconds 12 minutes, 19 seconds 5 minutes, 17 seconds 4 minutes, 43 seconds 11 minutes, 9 seconds. Intro to Excel Services Data Sources - PerformancePoint Services. The Excel Services Data Source in PerformancePoint 2010 allows you to create data using familiar Excel tools and methods that you can then surface in PerformancePoint scorecards. To demonstrate the use of the Excel Services Data Source, I'll walk you through creating a scorecard that shows information about U.S. state government finance.
The data for the this scorecard will be in an Excel workbook in a SharePoint document library. For this example, I've created a sample workbook containing data about U.S. state government finances and population. The data in my workbook came from the site I downloaded three workbooks from this site containing information about US state revenue, expense, and population in 2008. I consolidated this information into one workbook and then created a summary table called "StateFinances2008" containing simple metrics for each state like Revenue per Person and the Debt to Cash and Securities ratio. Creating simple budget KPIs from SharePoint Lists - PerformancePoint Services. In this post we're going to walk through how our favorite fictional company Litware uses PerformancePoint Services with SharePoint list data to do simple "under budget" KPIs.
In Litware's party planning committee we log how much we spend on events using a SharePoint list. Corporate's creating a corporate balanced scorecard using PerformancePoint Services, and they've asked us to contribute a KPI showing how we're doing. For now our KPI will be based on the data we have, and the rules will be >100% budget is warning, >120% budget is bad. Later we can swap in other sources of information, for example employee anticipation around the next golf scramble, into the KPI's definition to make it a more accurate or more predictive metric, and the changes will flow into the higher level scorecard that uses the KPI.
Here's a sample of our spending history list. Let's create the KPI and scorecard from this point. I launch Dashboard Designer from the Business Intelligence site template homepage. PerformancePoint Server for developers | SDK, Data sheets | MSDN. Create a Reporting Services report by using Dashboard Designer. Published: May 29, 2010 By using PerformancePoint Dashboard Designer, you can create Microsoft SQL Server Reporting Services (SSRS) reports for your dashboards.
A Reporting Services report is a report that is published to SQL Server Reporting Services and contains one or more charts and tables. By adding a Reporting Services report to a PerformancePoint dashboard, you can reuse an existing report. In addition, if the Reporting Services report contains at least one parameter, you can connect PerformancePoint dashboard filters to the Reporting Services report.
In Dashboard Designer, you do not actually create a Reporting Services report. To create a Reporting Services report, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS). When you create a Reporting Services report by using Dashboard Designer, you do it in several stages, as described in the following list: Create the basic structure of the Web Part. To create the basic structure of your report Web Part. Getting acquainted with PerformancePoint dashboards and Web Parts - SharePoint Server.
PerformancePoint dashboards and their Web Parts can offer you a world of information about your organization. Because PerformancePoint dashboards are continually connected to their data sources, the information in them is up-to-date and it is usually interactive, too. You can do any or all of the following in a PerformancePoint dashboard: Drill up or down in data Filter data to see just the information you need Explore data through actions on various menus Open reports in new windows Export reports to Microsoft Excel or PowerPoint Print dashboards and reports This article covers what you can expect to see on a PerformancePoint dashboard page and what is included in a PerformancePoint Web Part.
What do you want to know? What’s on a PerformancePoint dashboard page? PerformancePoint dashboards or dashboard pages vary considerably, depending on their purpose and their design. The Quick Launch pane Web Parts A link to Help In many cases, page navigation links and filters are also present. Filter. PerformancePoint Services Architecture in SharePoint Server 2010 - SharePoint in Pictures. PerformancePoint Services in SharePoint Server 2010. Learn about fundamental PerformancePoint Services concepts, procedures, and code samples, and find getting started information, troubleshooting tips, and other PerformancePoint Services resources. Last modified: June 03, 2011 PerformancePoint Services in Microsoft SharePoint Server 2010 is a SharePoint Server service application that you can use to gain insight into your organization's performance.
It enables users to create business intelligence (BI) dashboards with scorecard, report, and filter Web Parts that contain interactive data visualizations. The PerformancePoint Services documentation contains overview topics, how-to topics, and code examples for developing custom extensions for PerformancePoint Services. Applies to: SharePoint Server 2010 Other online documentation for PerformancePoint Services includes topics that describe how to use PerformancePoint Services applications and how to set up PerformancePoint Services.
How to navigate PerformancePoint dashboards and explore data - SharePoint Server. When you look at a PerformancePoint dashboard on a SharePoint site, you might see one or several items on it. Typically, but not always, the dashboard contains a scorecard, and some filters, charts and grids. Each scorecard and report is placed on the dashboard as a Web Part. You can navigate within a report or perform actions on the Web part itself. Dashboard can include more than one page. The dashboard in the example below shows a filter, links to more pages, a scorecard, an analytic bar chart, a KPI details report, and a pie chart. In some cases, the actions that you take in one Web Part affect the results that you see in another Web Part. You can easily view and explore data by using the scorecards and reports that are on a dashboard.
What do you want to do? Navigate in a dashboard The real power of a PerformancePoint dashboard lies in its interactivity. Moving around the dashboard Use your cursor to select the scorecard or report you want to focus on. Top of Page Top of Page . PerformancePoint « Dan English's BI Blog. Last year I did a posting on Using PowerPivot with PerformancePoint Services (PPS) 2010. I thought it would be a good idea to do an updated posting with the new release of PowerPivot that will be coming out this year to show the new features that you will be able to take advantage of now.
Before we get started I need to point out that if you setup your SharePoint environment with a fresh install of SQL Server 2012 that you will also need to download and install the Analysis Services ADOMD.NET (version 10.5) data provider from the SQL Server 2008 R2 SP1 Feature Pack. I had previously tried to reference PowerPivot SQL Server 2012 in the “Denali” CTP3 and in RC0 release and received the following error message when trying to configure the connection string in the PerformancePoint data source setup: An error occurred connecting to this data source.
What’s New? Okay, so now that we got that covered what are we able to do with the new release of PowerPivot? Hierarchies! Hierarchies Column Sorting. Using PowerPivot with PerformancePoint Services (PPS) 2010 « Dan English's BI Blog. UPDATE (6/20/2011): Modified table layout of step-by-step walkthrough to be two columns instead of three. Added a downloaded PDF file as well. UPDATE (2/24/2012): I have a blog for using PowerPivot 2012 with PerformancePoint Servers here - Using PerformancePoint Services (PPS) with PowerPivot SQL Server 2012 RC0. Analysis Services was one of the primary data sources with the previous version of PerformancePoint to get the most functionality out of the product. Now with the release of the 2010 product we have some new options and one of them is PowerPivot. PowerPivot is also a multi-dimensional data source and in this post I will talk about what this source provides for functionality and what it does not compared to Analysis Services.
First of all you will need to have an environment that has PerformancePoint Services configured. Some of the reasons that we might want to use PowerPivot in a PPS dashboard would be because: Enjoy! Download: Like this: Like Loading... Using Reporting Services in SharePoint Integrated Mode with PPS 2010 with SQL Server “Denali” CTP3 - PerformancePoint Services. The SQL Server team has made a small change to the location of the web service that PPS calls in order to render SQL Server Reporting Services reports when running in SharePoint Integrated mode. In this blog post, I’m going to go over how to work around that problem and get your reports rendering again. The changes in Denali now have SSRS running inside the SharePoint Shared Service architecture, which in the long term will make management of this service a lot easier for the people responsible for making sure the service is up and running.
As a consequence of this change, the web service that PPS relies on (ReportExecution2005.asmx) changed location. It is now located in the _vti_bin folder along with the other SharePoint web services. Using SQL 2008 you would give this: With Denali, you now have to give this: