Metric indicator dimension
In IBM® Cognos® TM1® Scorecarding, a metric indicator dimension provides more information about your key performance indicators (KPI) or metrics. Examples of metric indicators include Score, Status, and Trend.
The metric indicators in a scorecard solution measure the performance, status, and trends in key areas of a business by comparing current results to target values. For example, the Actual, Target, and Tolerance indicators for a metric are typically used to calculate the related Score, Status, and Trend indicators.
Cognos TM1 Scorecarding provides a set of built-in, predefined metric indicators. You can use the predefined metric indicators or create your own. You can also use standard TM1 functions and special scorecarding functions to calculate your metric indicators.
Metric indicators can be shown as numeric values or visually as traffic light and trend icons. The metric indicator dimension is typically shown in the column dimension title of a standard scorecard or cube view.
Renderer property for metric indicator icons
The Renderer property specifies the type of indicator icon to use as a visual reference to show the performance of a metric indicator. These icons display in metrics cubes and scorecard diagrams. You can set a different Renderer for each metric indicator.The valid options for the Renderer property are provided in the following list:
- Traffic light icon - Enter trafficLight in the Renderer property.
- Metric trend icon - Enter metricTrend in the Renderer property.
- Numeric - Leave the cell blank to display a numeric value instead of an indicator icon.
- Traffic light status indicator
- A traffic light or status indicator is an icon that shows the status of a metric indicator. The status is indicated by the color and the shape of the icon as described in the following table.
Traffic light icon | Description |
---|---|
A green circle icon indicates a satisfactory status for the associated metric indicator. | |
A yellow diamond icon indicates caution about the status for the associated metric indicator. | |
A red square icon indicates a warning about the status for the associated metric indicator. | |
This image represents an incomplete status, for when there is no data for the Actual or Target metric indicators. A score or status cannot be calculated when one of these values is missing. |
- Trend indicator
- A trend indicator shows how the value of one column compares to the value of another column. For example, a trend indicator shows the trend from the previous period to the current period by comparing values between periods. The trend indicator shows if the value is greater than, unchanged, or less than the value from the previous period.
Trend icon | Description |
---|---|
A green upward facing triangle icon indicates that the trend value is greater
than the previous period. For example, the value is greater than the previous month or quarter. |
|
A gray dash icon indicates that the trend value is unchanged. | |
A red downward facing triangle indicates that the trend value is less than the
previous period. For example, the value is less than the previous month or quarter. |
|
Blank cell | Indicates that the trend is incomplete for that period. A trend cannot be displayed when there is an incomplete status. For example, a trend cannot be displayed for the first time period, such as Q1 (quarter one). Previous data does not exist, even if the metric has a value for Actual, Target, Score, and Status. |
Default metric indicators
Cognos TM1 Scorecarding provides a collection of built-in metric indicators that are ready to use. When you create a metric indicator dimension, these members are automatically created and populated with suggested indicator names and calculations.
Cognos TM1 Scorecarding includes the following built-in metric indicators:
Metric indicator name | Description |
---|---|
Status | A calculated value that represents the performance of the score for a metric. The returned numeric value is displayed as a traffic light indicator icon to visually show status in grid views and diagrams.
Uses the
|
Trend | A calculated value that represents how a metric's performance has changed since the previous period. Evaluates a metric’s score and returns a value to indicate the current performance of the metric The result reflects only a positive or negative trend if the score changes more than 5% of tolerance. By default, this indicator is configured to display as a metric trend indicator icon to visually show the trend in grid views and diagrams.
Uses the
|
Actual | A value for the Actual indicator is derived from operational data. Populate this value from your existing Cognos TM1 data. |
Target | A target value defines a level of expected performance. Populate this value from your existing Cognos TM1 data. |
Tolerance | A tolerance value defines an acceptable range for a result that deviates from a set target. Enter this value or populate it from your existing Cognos TM1 data. |
Variance | Calculates the difference between the Actual and Target indicators. Uses the calculation: |
Variance Percent | Calculates the percent of difference between the Actual and Target indicators. Uses the calculation: |
Score | Calculates a metric’s score, which is based on the actual, target, and tolerance indicators. This value indicates whether a metric is on target, higher than the target, or less than the target, and by how much. It reflects the distance from the target as measured in units of tolerance. Values are reported in the range of -10 to 10 where a value of 0 indicates that the metric is on target. A positive score indicates that the metric is performing well. A negative score indicates that the metric is not performing well. Uses the
|
Score Change | Calculates the change in score by comparing the current value to the value from the previous time period. Uses
the Cognos TM1
|
Actual Trend | Not currently used. |
Actual Change Percent | Calculates the change in percent for the actual indicator by comparing the current value to the value from the previous time period. Uses the Cognos TM1
|
Status_1_Count | Internal use only. |
Status_0_Count | Internal use only. |
Status_-1_Count | Internal use only. |
User-defined metric indicators
Create your own user-defined metric indicators to measure the performance of a metric against a comparable metric, such as an industry-wide standard measurement.
For example, you might want to define metric indicators to monitor the performance of a forecast metric. In this scenario, you create a collection of derived and calculated metric indicators.
Create the following derived metric indicators and populate the indicators with existing forecast data.
- Forecast Actual
- Forecast Target
- Forecast Tolerance
Create the following calculated metric indicators and use metric indicator functions to populate them.
- Forecast Score - Use the
SCORE
function to calculate this value.For example:
=SCORE('Forecast Actual','Forecast Target','Forecast Tolerance')
- Forecast Status - Use the
SCORESTATUS
function to calculate this value.For example:
=SCORESTATUS('Forecast Score')
For the Renderer property, enter trafficLight to display a traffic light icon for this metric indicator.
- Forecast Trend - Use the
SCORETREND
function to calculate this value.For example:
=SCORETREND('Forecast Score')
For the Renderer property, enter metricTrend to display a trend icon for this metric indicator.
Metric indicator calculations and functions
You can use standard TM1 functions and a special set of metric indicator functions to define calculations for your metric indicators. A calculation for a metric indicator can provide a status, score, or trend value that is based on the other indicators for that same metric.
For example, you can use the metric indicator SCORE function to calculate a score for a metric depending on the Actual, Target, Tolerance indicators for the metric.
=SCORE('Actual','Target','Tolerance')
For more information about using calculations with your metric indicators, see the following topics:
- Metric indicator functions
- IBM
Cognos
TM1 Reference documentation,
Rules Functions
topic. - Dimension calculations