Key Performance Indicators (KPI) are financial and non-financial metrics used to quantify objectives to reflect strategic performance of an organization. KPIs are used in Business Intelligence to assess the present state of the business and to prescribe a course of action.
The KPIs defined in a cube can be viewed within the application.
Note: KPIs are only available when working with Analysis Services 2005 and higher. Only one KPI window per data source can be added to the report.
To view KPIs in the cube, click the By default, no KPI will have been selected to be displayed. To select the KPIs to view, click on the selection drop down in the window's toolbar:
KPIs are grouped in display folders to allow for easy navigation. Select the KPIs you wish to view by clicking on the checkbox next to the KPI. To select all KPIs in a display folder, check the box next to the display folder. |
button on the toolbar. This will open the KPI viewer window.
When working with KPIs, you can view them in two different modes:
Gauge Mode The default type to visualize KPIs is as a gauge. Gauges provide a graphical view of the KPI and are often used in dashboard creation. To view the KPIs as gauges:
The type of gauge that is displayed is configured within the KPI definition on the server. Below are two examples of gauges in the viewer.
Table mode In table mode the KPI results are displayed in tabular mode as shown in the figure below. By clicking on column headers you can sort and filter the displayed results. The type of status icon displayed is configured within the KPI definition on the server.
|
command on the KPI window's toolbar. 
Configure how the KPIs are printed and exported
To bring up the Print & Export Options dialog:
| • | Click on the arrow next to the  button and select the Print & Export Options command. |
| • | Click the button and click on the ellipsis next to the Export Settings option. |