Searching...
Filters
SmallMediumLarge
Home Print Show Topic URL Previous Next
IT Management Suite
Client Management Suite
Server Management Suite
Deployment Solution
Asset Management Suite
ServiceDesk

Setting the status of a KPI (advanced)

IT Analytics

IT Analytics Client and Server Management Content Pack can leverage some of the graphical capabilities of Analysis Services and Reporting Services. It looks for visual status indicators, such as a stoplight or other images. This functionality gives a quick, high-level view of the current state of defined KPI.

The Status Expression of the KPI is defined as a number between 1 and -1. The most flexible way of defining how these values are populated is through an MDX string.

This procedure is an example of enhancing the KPI that was previously created.

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.