This procedure is an example of creating KPIs for computers with critical patch vulnerability defined through the cube. The example highlights how this procedure automatically populates some of the MDX code that is needed to define the KPI.
To create KPIs
In the Symantec Management Console, on the Reports menu, click All Reports.
In the left pane, expand the Cubes folder.
Click Patch Management Cube.
Click anywhere inside the cube to display the Field List.
Click and drag the Software Update - Severity field into the Drop Row Fields Here section.
Click and drag Vulnerable Computer Count into the Drop Totals or Detail Fields Here section.
Click and drag Applicable Computer Count into the Drop Totals or Detail Fields Here section.
Right-click the cell in the cube that represents Vulnerable Computer Count with Critical Severity and click Use as KPI Value.
Right-click the cell in the cube that represents Applicable Computer Count with Critical Severity and click Use as KPI Goal.
In the New Key Performance Indicator section, verify that KPI Value and KPI Goal are defined.
Click Create KPI.
In the resulting pop-up window, in the KPI Name box, enter Computers with Critical Vulnerability.
Verify that the following boxes are correctly filled out:
Database Name. This box should be the name of the Analysis Services database that IT Analytics Solution is configured to use.
Cube Name. This box should already be set to the Patch Management Cube.
Associated Measure Group. This box should already be set to Applicable Patches.
Value Expression. This box should already be populated with the MDX code that represents the measure that was selected for the KPI Value.
Goal Expression. This box should already be populated with the MDX code that represents the measure that was selected for the KPI Goal. You might want to compare the number of vulnerable computers to a percentage of all applicable computers. By adding "0.1*" directly before the MDX string, you define your goal as 10% of all applicable computers. With this measure in place, any KPI value that is less than your goal is acceptable. Any value that is more than your goal is an undesirable state where there are too many computers in the environment with critical patch vulnerabilities.
Click Save Changes.
Click OK to allow the window to refresh.
In the left pane, open the Settings folder.
Click Key Performance Indicators.
The new KPI should now display in the list with the current value and goal already defined.
Imported Document ID: HOWTO62436
Subscribing will provide email updates when this Article is updated. Login is required.