PerformancePoint Server 2007 Planning Data Migration Tool

There are two primary steps to a Migration in V1, with many tedious “sub-steps”.  The First step in the process is to Migrate the Application, this part of the process migrates: Security roles Structural metadata: all model site, model, dimension, and member set definitions Data Sources and Data Destinations Calculation rules and any associated job…


PerformancePoint Dashboard Designer Ribbon

We decided to adopt the key elements of the new Office user experience in early spring 2006 as Microsoft Office 2007 was in the last phases of completion. The ribbon was one of the key elements of the updated Office experience we decided to look into. The ribbon looked scalable and promised a better way…


Analytic chart and grid design

One of the improvements we’ve made in PerformancePoint Monitoring CTP3 is an improved design experience for analytic charts & grids. It’s a small increment in terms of requested/planned capabilities, but it’s leaps and bounds above CTP2. (Which involved a textbox and square-bracket/curly-brace/parenthesis counting. you had to know MDX, and the unique IDs of metadata in…


How do I create a dashboard parameter that can drive multiple analytic views

You can create a 2-column list (either in SQL Server or Excel). The first column will be passed to the analytic view as the UniqueName parameter. The second column will be used as the caption displayed to the user on the scorecard. For example this table: Will show like this to the user: The text…


KPI Calculations – Best Practices

Best Practices on Using Calculations · Use calculations only with Standard KPIs (non leaf level). · Accept the default values for Standard KPIs (leaf level) and Objective KPIs. Detailed Description of Behavior To understand how the Calculation setting affects a KPI, it is important to understand the differences between three types of KPIs: · Standard…


How do I integrate SSRS Reports with Dashboard Filters

PerformancePoint Monitoring Filters work with SSRS reports, both relational and OLAP. To configure a dashboard pages to use common filters to drive SSRS reports and other PerformancePoint views, follow the below steps. NOTE: this functionality is dependent on CTP3 or later releases of PerformancePoint Monitoring. For this example, we will configure a dashboard configuring containing…


How do I connect to an Analysis Services 2000 cube with PerformancePoint Monitoring

Currently the product uses the XMLA provider to connect to Analysis Services data sources. This will result in an error when trying to connect to an Analysis Services 2000 cube. In order to connect to an Analysis Services 2000 cube, you need to manually enter a connection string in the Data Source as follows: 1….


Creating a Trend Indicator for a KPI in a Scorecard

Creating a Trend Indicator for a KPI in a Scorecard Trend indicators can be created in your scorecards as an additional target value. Additionally, if you are importing SSAS 2005 KPIs, trend arrows are created for you automatically, if the KPI you are importing has a trend associated with it. A scorecard is shown below…


Strategy Maps in PerformancePoint Server

NOTE: This article was written with PerformancePoint Server 2007 (CTP3). UI and features subject to change. One of the strategic benefits of performance scorecards is the ability to understand cause-and-effect relationships between scorecard metrics and objectives. For example: Does an increase in “cost of goods sold” affect the organization’s profitability? How does employee attrition rate…


How do I make a dashboard show up in the tabs in SharePoint

If you want to create an experience like the following, where the users access the dashboard through the top-level SharePoint pages, not through navigating through a document library, here’s how you do it. 1. Deploy your dashboard to SharePoint as usual. You may want to change your master page to be the same one used…