To set the status of a KPI

1. In the Symantec Management Console, on the Settings menu, click Notification Server > IT Analytics Settings.

2. In the left pane, expand the Settings folder.

3. Click Key Performance Indicators to edit the KPI that was already created.

4. In the Status Expression box, click MDX Expression.

5. In the text area box that pops up, enter the following MDX code:

   CASE
   WHEN
   aggregate({[Software Update].[Software Update - Severity].&[Critical]},
   [Measures].[Vulnerable Computer Count]) 
   < 0.1 * aggregate({[Software Update].[Software Update - Severity].&[Critical]},
   [Measures].[Applicable Computer Count])
   THEN   1
   WHEN
   aggregate({[Software Update].[Software Update - Severity].&[Critical]},
   [Measures].[Vulnerable Computer Count])
   > 0.25 * aggregate({[Software Update].[Software Update - Severity].&[Critical]},
   [Measures].[Applicable Computer Count])
   THEN   -1
   ELSE   0
   END

6. For Status Graphic, click Traffic Light.

7. Click Save Changes.

8. Refresh the list of KPIs.

   A stoplight should display under the Status column. It indicates the current status for this KPI.