Defining database performance ranges for measures
A performance range is a set of five index ranges, each of which uses a color and a label to characterize performance. An index is a percentage value that compares a measure’s actual performance against a comparative value, such as a target or budget. The default label for an index range of 160–200% is very good, for
105–160% is good, for 95–105% is caution, for 50–95% is poor, and for 0–50% is very poor. Ranges cannot overlap.
The performance range specifies the color of measures and locations in books, maps, and views. For this reason, color choices must be readily distinguishable. For example, two shades of the same color can be difficult to tell apart. You can use either the web-safe or standard Windows color palette. For consistency of display across Metrics Management clients, choose colors from the web-safe color palette.
Metrics Management supports customizing the performance range settings for the database. These customized settings apply to all new measures. These settings also apply to existing measures for which a user has not modified the performance ranges. Users can define index ranges that differ from the database settings, on a measure-by-measure basis.
How to define database performance ranges
1 Choose SetupConfigure.
2 In Performance Ranges, shown in Figure 1‑20, perform any of the following tasks:
Figure 1‑20 Defining index values for a database
*To define the lower limit of an index range, in Begins at, type or select a value. To define the upper limit of the index range, in the range immediately above, in Begins at, type or select a value. That value is both the upper limit of the first range and the lower limit of the next range. In the example shown in Figure 1‑20, the upper limit of index range 3 is the lower limit of index range 4.
*To define the color of an index range:
1 Choose Color beside the range.
2 In Color, to define a palette, select Web browser safe colors, as shown in Figure 1‑21. Alternatively, you can use Standard Windows colors, but some colors appear differently in Metrics Management clients.
Figure 1‑21 Choosing the web browser safe palette
3 Select a color from one of the palettes. Then, choose OK.
*To change a label’s text color, from Text color, select a color.
*To change a label’s name, in Identifier, type a label.
3 Choose Save.