Lesson 7: Defining Key Performance Indicators (KPIs)

In this lesson, you learn to define Key Performance Indicators (KPIs) in your Microsoft SQL Server 2005 Analysis Services (SSAS) project. KPIs provide a framework for defining server-side calculations that measure your business, and they standardize how the resulting information is displayed. KPIs can be displayed in reports, portals, and dashboards, through data access APIs, and through Microsoft tools and third-party tools. KPIs are metadata wrappers around regular measures and other Multidimensional Expressions (MDX) expressions. For more information, see Key Performance Indicators.


A completed project through Lesson 6 is available by downloading and installing the updated samples. For more information, see Obtaining Updated Samples in Installing Samples.

This lesson contains the following task:

  • Defining and Browsing KPIs
    In this task, you define KPIs in the Form view and then switch to the Browser view to browse the cube data by using the KPIs.

Next Lesson

Lesson 8: Defining Actions

See Also


Analysis Services Tutorial Scenario
SQL Server 2005 Analysis Services Tutorial

Other Resources

Key Performance Indicators

Help and Information

Getting SQL Server 2005 Assistance