When Microsoft Office Business Scorecard Manager KPIs are generated from Microsoft SQL Server 2005 Analysis Services KPIs, an actual value and three target values (Goal and Status, Trend, and Weight) are created for each Business Scorecard Manager KPI. These values are displayed in Business Scorecard Builder when the new Business Scorecard Manager KPIs are inserted in a workspace file.
The Data Mappings pane of the KPI Actual Editor or Target Editor displays the following properties for the actual or target values:
-
Data Mappings
A single data source is created on the Business Scorecard Manager server for all of the Business Scorecard Manager KPIs that are generated from SQL Server 2005 Analysis Services KPIs. The name of the data source is formatted as follows:
[SQL Server 2005 Analysis Services server name]$$[Database name]$$[Cube name]
-
Time Intelligence
The first cube dimension where type=time is used as the time dimension for the KPI. If no such dimension exists, the first dimension is used, and the top-level member of the dimension is used as both the current and the previous time dimension member.
-
Advanced Formulas
The advanced formula comes from SQL Server 2005 Analysis Services. It points to the business logic in a cube for calculating KPI status, trend, and weight.
The Thresholds pane of the Target Editor displays the banding settings for the status values of the associated KPI. It also displays the banding settings for trend values of the associated KPI. The scoring pattern for all target values is either Increasing is Better or Decreasing is Better, and the band-by method is always Stated Score (advanced).
Only three-level and five-level standard indicators are supported by KPIUtil.exe. When KPIs are exported from SQL Server 2005 Analysis Services to Business Scorecard Manager, the business logic behind the Business Scorecard Manager KPIs is sourced from the SQL Server 2005 Analysis Services KPIs based on the following boundaries for three-level indicators:
-
Best: 1
-
Boundary 2: 0.5
-
Boundary 1: -0.5
-
Worst: -1
And the following boundaries for five-level indicators:
-
Best: 1
-
Boundary 4: 0.5
-
Boundary 3: 0.25
-
Boundary 2: -0.25
-
Boundary 1: -0.5
-
Worst: -1
Note: The type of icon that appears depends on whether you are working with a status or a trend value.
To view the display-only data mappings for an actual value
-
In Workspace Browser, click a KPI that you generated from a SQL Server 2005 Analysis Services KPI.
Note: The new KPI must exist in a workspace file before you can view its data mappings. For more information, see Insert Newly Generated Business Scorecard Manager KPIs in a Workspace File.
-
In the right pane of the window, on the Definition tab, under Actual and Targets, right-click Actual, and then click Edit.
The Actual Editor opens.
-
In the navigation pane of the editor, click Data Mappings.
In the right pane of the Actual Editor, the display-only properties (Data Mappings, Time Intelligence, and Advanced Formulas) for the actual value appear.
To view the display-only data mappings for a target value
-
In Workspace Browser, click a KPI that you generated from a SQL Server 2005 Analysis Services KPI.
Note: The new KPI must exist in a workspace file before you can view its data mappings. For more information, see Insert Newly Generated Business Scorecard Manager KPIs in a Workspace File.
-
In the right pane of the window, on the Definition tab, under Actual and Targets, right-click Goal and Status, Trend, or Weight, and then click Edit.
The Target Editor opens.
-
In the navigation pane of the editor, click Data Mappings.
In the right pane of the Target Editor, the display-only properties (Data Mappings, Time Intelligence, and Advanced Formulas) for the target value appear.
To view the display-only boundary values for a target value
-
In Workspace Browser, click a KPI that you generated from a SQL Server 2005 Analysis Services KPI.
Note: The new KPI must exist in a workspace file before you can view its boundary values. For more information, see Insert Newly Generated Business Scorecard Manager KPIs in a Workspace File.
-
In the right pane of the window, on the Definition tab, under Actual and Targets, right-click Goal and Status, Trend, or Weight, and then click Edit.
The Target Editor opens.
-
In the navigation pane of the editor, click Thresholds.
In the right pane of the Target Editor, the display-only boundary values for the target value appear.