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...

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...

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...

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...

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...

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...

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...

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...

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...

The PPS Planning Server has the ability to define complex cube security as part of developing a model. Once these have been published to Analysis Services as a cube they can be analyzed using the capabilities of the Monitoring Server. However, by default...

Monitoring Server has several roles that define the permissions to administer or create dashboard elements. Active Directory users and groups are assigned to these roles using the Dashboard Builder. In addition to the basic roles on the system users and...

Trend charts use Data Mining algorithms in SQL Server Analysis Services 2005 to predict future values of KPIs in your scorecard. KPIs can be sourced from any data source, Excel, SSAS, SQL, etc. Because the trend charts utilize the Time Series Data Mining...

Bulk edit is a feature that allows you to change the properties for multiple objects at a time. Bulk edit can only be performed on items in a workspace. If you need to make changes to items on the server, you will need to download items into a workspace...

With PerformancePoint Monitoring Server you can directly import SSAS 2005 KPIs into a scorecard using the Scorecard wizard. The following steps illustrate this process: 1. Create your data source and publish to the server. 2. Right click on Scorecards...

Security considerations for Monitoring Server Monitoring Server provides deployment and configuration options to allow you to tailor the application to help meet your company requirements for securing your business data. Being informed on what the...

PerformancePoint Monitoring and Analytics (PPS M&A) supports the use of multiple data sources to use inside a Scorecard. One of the supported data sources are Excel Services. Excel Services are part of Microsoft Office SharePoint Services (MOSS) 2007...

To migrate your content from one environment to another (for example: development to test, test to production, etc) we recommend the following. Note that many of the steps are optional, depending on whether you have the same users/content creators in...

With PerformancePoint Monitoring Server you can source data in scorecards from a variety of data sources, including Excel 2007, Excel Services and Relational Tables. When using Excel or Relational data sources, it is best to format your data in a specific...

Planning Server installation Planning Server is deployed in two stages: software installation, and software configuration. PerformancePoint Planning Server software is copied to the target computer and then configured during the second stage of...

PerformancePoint Planning cubes are generally more targeted smaller cubes than your general cubes created from your data warehouse. These cubes require a different finesse when creating scorecards from them. When creating scorecards off of PerformancePoint...

When integrating PerformancePoint Planning with PerformancePoint Monitoring, you need to keep the following in mind: PerformancePoint Planning cubes are recreated in each environment that they are placed into, causing the member unique keys to change...

To create a custom indicator follow the below steps: 1. Right click on the Indicators folder in the Workspace Browser panel and select New Indicator . 2. Select New Wizard and Click OK . 3. Provide a name for your indicator, optionally select...

Time Intelligence in PerformancePoint Monitoring allows you to map your data source to a reference date and easily build time dynamic filters based off of the current date. Dashboard filters can be created that build time sets based on the current date...