Key Performance Indicator -- System Center Cube

Organizations and businesses can use key performance indicators (KPIs) to quickly estimate the health of an enterprise by measuring its progress toward a predefined goal. Each KPI has a target value and an actual value. The target value is a quantitative goal that is critical to the success of the organization.

Large amounts of data are filtered to one discrete value that can be used to monitor performance and progress towards goals and benchmarks. Some examples of KPIs are a college having a goal that 90% of their students graduate within four years or a basketball team with a goal of causing the opposing team to shoot less than 50 percent for a game. You can use a scorecard to show a group of KPIs, providing in one instantaneous snapshot the overall health of a business.

The following is an example KPI:

<KPI ID="IncidentResolutiuonKpi" >

<Caption> The ratio of incidents resolved </Caption>

<Value>IIF(([Measures].[IncidentDimCount])&gt; 0,([Measures].[IncidentsResolvedCount]/[Measures].[IncidentDimCount]),null)</Value>

<Goal>1.0</Goal>

<GreenThreshold> 0.75</GreenThreshold>

<YellowThreshold>0.5 </YellowThreshold>

<Direction>Up</Direction>

<StatusGraphic>Thermometer</StatusGraphic>

</KPI>

The following table describes KPI attributes.

Attribute	Required	Values	Definition
ID	Yes	String	Name of the KPI
Caption	Yes	String	Description of the KPI
Value	Yes	String	MDX script defining the numeric value of the KPI
Goal	Yes	String	​The target value of the KPI
Green Threshold	Yes	String (between 0.1 and 1)	​Any number that is above or below this threshold, depending on the direction, is marked as green in the status symbol.
​Yellow Threshold	Yes	String (between 0.1 and 1)	Any number that is above or below the threshold, depending on the direction, but does not meet the green threshold is marked as yellow in the status symbol. A number that does not meet the yellow threshold is marked as red in the status symbol.
​Direction	Yes	​(Up, Down)	​If the direction is up, any numbers above the green or yellow threshold are marked with the corresponding symbol. Similarly for down, numbers below the green or yellow thresholds are marked with the corresponding symbol.
​Status Graphic	Yes	​(Shapes, TrafficLight, RoadSigns, Gauge, ReversedGauge, Thermometer, Cylinder, Faces, VarianceArrow)	​The symbol that will represent the KPI.