Detailed mapping information

Aktualisiert: 2009-04-23

This section details how data was converted from Business Scorecard Manager 2005 to Microsoft Office PerformancePoint Server 2007 during the migration process.

KPIs

Most of the data for the key performance indicators (KPIs) will successfully convert to PerformancePoint Server.

General properties

All the fields under general properties convert except for the comments field.

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
KPI Name	Name	KPI Properties – General Properties
Description	Description	KPI Properties – General Properties
Person Responsible	Owner	KPI Properties – General Properties
Display Folder	Display Folder	KPI Properties – General Properties
Document Links
Name	Name	KPI Properties – Custom Properties
Description	Description	KPI Properties – Custom Properties
Type	Type	KPI Properties – Custom Properties
Path	Value	KPI Properties – Custom Properties
Comments	Does not convert
Custom properties
Name	Name	KPI Properties – Custom Properties
Description	Description	KPI Properties – Custom Properties
Type	Type	KPI Properties – Custom Properties
Value	Value	KPI Properties – Custom Properties
Permissions
User	User	KPI Properties – Permissions
Role	Role	KPI Properties – Permissions

Actual and target metrics

Data mapping

Most of the data mapping information converts to PerformancePoint Server. Exceptions include time intelligence fields and metric description because users did not assign responsibility at that level.

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
Metric Name	Metric Name	KPI Summary - Name
Description	Does not convert
Person Responsible	Does not convert
Display Folder	Does not convert
Comments	Does not convert
Detailed Properties
Unit of Measure	Does not convert
Frequency	Does not convert
Display Format	Display Format	KPI Summary – Display Format
Decimals	Decimals	KPI Summary – Display Format
Symbols on Left	Symbols on Left	KPI Summary – Display Format
Symbols on Right	Symbols on Right	KPI Summary – Display Format
Negative Numbers	Negative Numbers	KPI Summary – Display Format
Show Zero As	Show Zero As	KPI Summary – Display Format
Tool Tip Text	Tool Tip Text	KPI Summary – Display Format
Data Mapping
Data Source Name	Data Source Name	KPI details – Related data source
Measure	Select a measure	KPI Summary - data mapping
Time Dimension	Does not convert
Time Intelligence
Dimension Level	Does not convert
Current lag	Does not convert
Previous Lag	Does not convert
Static Members
Current Time Dim	Does not convert
Previous Time Dim	Does not convert
Data Filters
Name	Name	KPI Summary – data mapping
Default	Default	KPI Summary – data mapping
Advanced Formula
MDX Tuple formula	Use MDX Tuple formula	KPI Summary – data mapping
Thresholds
Indicator name	Related Indicator Name	KPI details – Related Indicator
Threshold boundaries	Thresholds	KPI Summary - thresholds
Banding settings
Pattern	Scoring pattern	KPI Summary – Thresholds – set scoring pattern and indicators – scoring pattern
Band By	Banding method	KPI Summary – Thresholds – set scoring pattern and indicators – scoring pattern
Worst Value	Enter worst value	KPI Summary – Thresholds – set scoring pattern and indicators - details

KPI report view

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
Report View Name	Name	Report Properties – General Properties
Description	Description	Report Properties – General Properties
Person Responsible	Owner	Report Properties – General Properties
Comments	Does not convert
Configuration
Data source	Data source	Report Summary – Pivot chart
Data Details	Data Details	Report Summary – Pivot chart
Type	Type	Report Summary – Pivot chart
Append Page filters	Does not convert
Render as Image	Render as Image	Report Summary – Pivot chart

Scorecards

Most of the data for the scorecards gets converted to PerformancePoint Server.

General properties

All the fields under general properties convert except for the comments field.

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
KPI Name	Name	Scorecard Properties – General Properties
Description	Description	Scorecard Properties – General Properties
Person Responsible	Owner	Scorecard Properties – General Properties
Display Folder	Display Folder	Scorecard Properties – General Properties
Document Links
Name	Name	Scorecard Properties – Custom Properties
Description	Description	Scorecard Properties – Custom Properties
Type	Type	Scorecard Properties – Custom Properties
Path	Value	Scorecard Properties – Custom Properties
Comments	Does not convert
Custom properties
Name	Name	Scorecard Properties – Custom Properties
Description	Description	Scorecard Properties – Custom Properties
Type	Type	Scorecard Properties – Custom Properties
Value	Value	Scorecard Properties – Custom Properties
Permissions
User	User	Scorecard Properties – Permissions
Role	Role	Scorecard Properties – Permissions

Scorecard elements

For the scorecard elements, each of the KPIs is converted and displayed within the scorecard.

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
Scorecard elements		Scorecard Summary – General Properties

Scorecard views

Business Scorecard Manager 2005 Item	PerformancePoint Server conversion	PerformancePoint Server location
Scorecard Views	Only the first view converts
General Properties
Name	Does not convert
Description	Does not convert
Person Responsible	Does not convert
Comments	Does not convert
Dimensionality
Data Source Name	Data Source Name	Scorecard Summary– details – data source
Page filters	Does not convert
Column Headers
Text properties
Font	Displayed on column view	Scorecard Summary
Vertical alignment	Displayed on column view	Scorecard Summary
Horizontal alignment	Displayed on column view	Scorecard Summary
Color Properties
Text color	Displayed on column	Scorecard Summary
Background color	Displayed on column	Scorecard Summary
Column Members	Displayed on column view	Scorecard Summary
Actuals and Targets	Displayed on column view	Scorecard Summary
Additional Columns	Displayed on column view	Scorecard Summary
Row Headers
Text properties
Font	Displayed on column view	Scorecard Summary
Vertical alignment	Displayed on column view	Scorecard Summary
Horizontal alignment	Displayed on column view	Scorecard Summary
Color Properties
Scorecard text color	Displayed on column view	Scorecard Summary
Scorecard Background color	Displayed on column view	Scorecard Summary
Objective text color	Displayed on column view	Scorecard Summary
Objective background color	Displayed on column view	Scorecard Summary
KPI Text color	Displayed on column view	Scorecard Summary
KPI background color	Displayed on column view	Scorecard Summary
Member Text color	Displayed on column view	Scorecard Summary
Member background color	Displayed on column view	Scorecard Summary
Row Members	Displayed on column view	Scorecard Summary
Cell Options
Text properties
Font	Displayed on column view	Scorecard Summary
Vertical alignment	Displayed on column view	Scorecard Summary
Horizontal alignment	Displayed on column view	Scorecard Summary
Color Properties
Border color	Does not convert
Other Properties
Show empty cell	Show empty cells as	Scorecard Summary View Options
Show errors	Show errors cells as	Scorecard Summary View Options
Default expansion depth	Does not convert
Show grid lines	Show grid lines	Scorecard Summary View Options
Show +/-	Show row expansion options (+/-)	Scorecard Summary View Options
Expand scorecard	Does not convert
Hide scorecard	Hide scorecard	Scorecard Summary - View Options
Toolbar options
Show Toolbar	Show scorecard Toolbar	Scorecard Summary Toolbar Options
Show expand button	Show expand all	Scorecard Summary Toolbar Options
Show collapse button	Show collapse all	Scorecard Summary Toolbar Options
Show Page filter Button	Does not convert
Show status filter Button	Show status filter	Scorecard Summary Toolbar Options
Show sort and filter mode button	Show sort and filter	Scorecard Summary Toolbar Options
Display Page filters by default	Does not convert
Display Status filters by default	Display Status filters	Scorecard – summary – Toolbar Options
Enable cell selection	Does not convert
Allow annotations		Scorecard Summary View Options
Pass cell selection to report view	Does not convert

Report view

Reports that are attached to scorecards are successfully converted during migration. However, reports are no longer associated with a scorecard. All reports that are attached to either scorecards or KPIs are converted to first class objects. The reports now display in the workspace browser. In PerformancePoint Server, you must first create a dashboard and then add both the scorecard and the report view to the dashboard.

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
Report View Name	Name	Report Properties – General Properties
Description	Description	Report Properties – General Properties
Person Responsible	Owner	Report Properties – General Properties
Comments	Does not convert
Configuration
Data source	Data source	Report Summary – Pivot chart
Data Details	Data Details	Report Summary – Pivot chart
Type	Type	Report Summary – Pivot chart
Append Page filters	Does not convert
Render as Image	Render as Image	Report Summary – Pivot chart

Data Sources

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
Data source Name	Name	Data sources Properties – General Properties
Description	Description	Data sources Properties – General Properties
Person Responsible	Owner	Data sources Properties – General Properties
Display Folder	Display Folder	Data sources Properties – General Properties
Document Links
Name	Name	Data sources Properties – Custom Properties
Description	Description	Data sources Properties – Custom Properties
Type	Type	Data sources Properties – Custom Properties
Path	Value	Data sources Properties – Custom Properties
Comments	Does not convert
Custom properties
Name	Name	Data sources Properties – Custom Properties
Description	Description	Data sources Properties – Custom Properties
Type	Type	Data sources Properties – Custom Properties
Value	Value	Data sources Properties – Custom Properties
Connection
Server name	Server	Data sources summary – Connection settings
Database name	Database	Data sources summary – Connection settings
Database roles	Roles	Data sources summary – Connection settings
Connection string	Connection string	Data sources summary – Connection settings
Cube Name	Cube	Data sources summary – Connection settings
Cache interval in minutes	Interval	Data sources summary – Cache settings
Permissions
User	User	Data sources Properties – Permissions
Role	Role	Data sources Properties – Permissions

Indicators

Business Scorecard Manager 2005 item	PerformancePoint Server conversion	PerformancePoint Server location
General Properties
Indicator Name	Name	Indicator Properties – General Properties
Description	Description	Indicator Properties – General Properties
Person Responsible	Owner	Indicator Properties – General Properties
Display Folder	Display Folder	Indicator Properties – General Properties
Comments	Does not convert
Indicator band
Display Name	Display Name	Indicator Summary
Text Color	Text Color	Indicator Summary
Background color	Background color	Indicator Summary
Image	Image	Indicator Summary
Permissions
User	User	Indicator Properties - Permissions
Role	Role	Indicator Properties - Permissions

Download this book

This topic is included in the following downloadable book for easier reading and printing:

• Monitoring Server Operations Guide for PerformancePoint Server 2007

See the full list of available books at Downloadable content for PerformancePoint Monitoring Server.

Siehe auch

Aufgaben

Migrating files

Konzepte

What is migrated from Business Scorecard Manager 2005?
PerformancePoint Server 2007 Scorecard Migration Tool