The Traffic Lighting analysis tool color-codes data cells based on dimension member values. You can base color-coding on a comparison of two dimension members or by fixed limits on one dimension member. Colors graphically associate member values, whether they are sorted or ranked. Traffic Lighting definitions are maintained as the document is pivoted and changed.
The Information panel Traffic Lighting segment displays the Traffic Lighting definitions that color-code the current data object.
Traffic Lighting definitions are created in the Traffic Lighting dialog box:
Control | Description |
|---|---|
Apply Traffic Lighting To: | Specifies the dimension to which traffic lighting is applied. |
Comparing It To: | Specifies the dimension to which the preceding dimension is compared. |
Assign Limits | Specifies the interval, set point, and color parameters that compose the traffic lighting definition. |
% Differences | Indicates that the color-coding is based on the percent difference of the compared members. When disabled, color-coding is based on the value difference of the compared members. |
Enable Financial Intelligence | Enables Oracle | Hyperion data sources to treat expenses and liabilities as negative values. Works in cooperation with the % differences option to reflect variance and variance percent calculations for the traffic lighting dialog box. |
Advanced | Aggregates or separates dimension member combinations. |
Apply | Applies the definition to the document. |