Applying Conditional Highlighting to a Table

Overview of Conditional Highlighting for Tables

You can use conditional highlighting in a table viewer to emphasize values that meet a specific condition. Conditions for highlighting are stored as highlighting rules. Highlighting rules specify which values are highlighted, and also specify style information for the highlighted values.
You can specify several options for the highlighting style, including the font, text color, and cell color. You can also add an image or text to the highlighted cells.
For example, you can create a highlighting rule that highlights all of the values that are greater than $350,000.00 for a particular measure, and specifies that the highlighted values have bold text and a yellow background.

Create a New Highlighting Rule for a Table

To create a new highlighting rule for a table:
  1. On the table viewer menu, select Datathen selectConditional Highlighting.
  2. In the Conditional Highlighting dialog box, click New to create a new rule.
  3. On the Rule tab, specify the conditions for the rule:
    1. Specify which Measure the rule applies to.
    2. Specify a Condition for the rule:
      Rule Conditions
      Is equal to
      a matching value must match the rule value exactly.
      Is not equal to
      a matching value must not match the rule value exactly.
      Less than
      a matching value must be less than the rule value.
      Less than or equal to
      a matching value must be less than or equal to the rule value.
      Greater than
      a matching value must be greater than the rule value.
      Greater than or equal to
      a matching value must be greater than or equal to the rule value.
      Is between
      a matching value must be between the Min value and Max value for the rule.
      Is missing value
      missing values match the rule.
    3. Specify a Value for the rule. You can either enter a numeric value or select a measure from the drop-down list.
      Note:
      • If you selected the Is missing value condition, you don't need to specify a value.
      • If you selected the Is between condition, specify a minimum value in the Min value field and a maximum value in the Max value field.
    4. Specify which hierarchy levels the rule applies to.
      • To apply the rule to any level, select All hierarchy levels.
      • To apply the rule to specific levels:
        1. Select Selected hierarchy levels.
        2. Click Select. A new page appears, which enables you to select hierarchy levels.
        3. Select the levels that you want to apply the rule to, or click Set to Current to select the lowest level that is currently visible for each hierarchy.
        4. Click OK to return to the first page of the Conditional Highlighting dialog box.
  4. (Optional) Specify color and font options for the highlighted values on the Color and Font tab:
    • In the Font field, select a typeface from the first drop-down list.
    • In the Font field, select a font size from the second drop-down list.
    • In the Font style field, select bold (bold text) or italic (italic text).
    • In the Font style field, click font color icon and select a font color.
    • In the Font style field, click fill color icon and select a background color.
    The Preview area at the bottom of the Conditional Highlighting dialog box shows an example highlighted value that uses your settings.
  5. (Optional) Specify a text string to add to your highlighted values on the Image and Text tab:
    1. Select Highlight by adding an image or text.
    2. In the Add field, select Text.
    3. Specify a Position:
      To right of cell value
      the text is added to the right of the cell value.
      To left of cell value
      the text is added to the left of the cell value.
      In place of cell value
      the text replaces the cell value.
    4. In the Text field, enter the text that you want to add to the highlighted values.
    5. Specify font options:
      • In the Font field, select a typeface from the first drop-down list.
      • In the Font field, select a font size from the second drop-down list.
      • In the Font style field, select bold (bold text) or italic (italic text).
      • In the Font style field, click font color icon and select a font color.
    The Preview area at the bottom of the Conditional Highlighting dialog box shows an example highlighted value that uses your settings.
  6. (Optional) Specify an image to add to your highlighted values on the Image and Text tab:
    1. Select Highlight by adding an image or text.
    2. In the Add field, select Image.
    3. Specify a Position for the image:
      To right of cell value
      the image is added to the right of the cell value.
      To left of cell value
      the image is added to the left of the cell value.
      In place of cell value
      the image replaces the cell value.
    4. Click image icon and select an image.
    The Preview area at the bottom of the Conditional Highlighting dialog box shows an example highlighted value that uses your settings.
  7. Click OK to save the new highlighting rule and return to the first page of the Conditional Highlighting dialog box.
  8. Click OK to apply your changes and return to the main SAS Web OLAP Viewer page.

Edit a Highlighting Rule for a Table

To edit an existing highlighting rule:
  1. From the table viewer menu, select Datathen selectConditional Highlighting to open the Conditional Highlighting dialog box.
  2. In the Rules list field, select the rule that you want to edit, and then click Edit.
  3. Make changes to the rule as appropriate, and then click OK to save your changes and return to the first page of the Conditional Highlighting dialog box.
  4. Click OK to apply your changes and return to the main SAS Web OLAP Viewer page.

Remove a Highlighting Rule from a Table

To remove a highlighting rule:
  1. From the table viewer menu, select Datathen selectConditional Highlighting to open the Conditional Highlighting dialog box.
  2. In the Rules list field, select the rule that you want to remove, and then click Delete.
  3. Click OK to apply your changes and return to the main SAS Web OLAP Viewer page.