Detailed mapping information

PerformancePoint Server 2007

更新: 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:

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

另请参阅

显示: