July 2007 - Posts

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. Read More...
Posted 20 July 07 02:16 by mswarner | 7 Comments   
Filed under
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 Read More...
Posted 20 July 07 01:44 by mswarner | 1 Comments   
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: Read More...
Posted 20 July 07 12:46 by mswarner | 2 Comments   
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 Read More...
Posted 20 July 07 02:01 by mswarner | 1 Comments   
Filed under
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 Read More...
Posted 20 July 07 01:48 by mswarner | 9 Comments   
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 Read More...
Posted 20 July 07 01:46 by mswarner | 0 Comments   
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 Read More...
Posted 20 July 07 01:43 by mswarner | 1 Comments   
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 Read More...
Posted 20 July 07 01:42 by mswarner | 4 Comments   
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. Read More...
Posted 20 July 07 01:38 by mswarner | 1 Comments   
Using secured Planning cubes with Monitoring Server
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 Read More...
Posted 12 July 07 01:44 by mswarner | 1 Comments   
Filed under ,
Application Security for Monitoring Server
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 Read More...
Posted 12 July 07 01:43 by mswarner | 1 Comments   
Filed under
Creating Trend Charts in M&A
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 Read More...
Posted 12 July 07 01:41 by mswarner | 3 Comments   
Filed under ,
Using Bulk Edit in M&A
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, Read More...
Posted 12 July 07 01:40 by mswarner | 1 Comments   
Filed under , ,
Importing SQL Server Analysis Services 2005 KPIs into Scorecards
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 Read More...
Posted 12 July 07 01:39 by mswarner | 5 Comments   
Filed under
Security Considerations for Monitoring Server
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 options Read More...
Posted 12 July 07 01:38 by mswarner | 6 Comments   
Filed under
How to use Excel Services as a Data source in PerformancePoint Monitoring
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. Read More...
Posted 12 July 07 01:37 by mswarner | 4 Comments   
Filed under
Migrating M&A data from one Environment to Another
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 Read More...
Posted 12 July 07 01:35 by mswarner | 0 Comments   
Working with Tabular Data Sources in PerformancePoint Monitoring
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 Read More...
Posted 12 July 07 01:33 by mswarner | 1 Comments   
Filed under ,
PerformancePoint Planning Installation
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 setup. Read More...
Posted 02 July 07 05:37 by mswarner | 6 Comments   
Creating KPIs from PerformancePoint Planning Cubes
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 Read More...
Posted 02 July 07 05:35 by mswarner | 3 Comments   
Filed under ,
Integrating M&A with Planning - Best Practices
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 Read More...
Posted 02 July 07 05:33 by mswarner | 1 Comments   
How do I create a custom indicator in M&A?
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 a folder Read More...
Posted 02 July 07 05:32 by mswarner | 0 Comments   
Working with Time Intelligence in PerformancePoint Monitoring
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 Read More...
Posted 02 July 07 05:31 by mswarner | 3 Comments   

Search

This Blog

Microsoft BI Sites

Syndication

Page view tracker