SQL Server 2008 Books Online (November 2009)
Lesson 7: Defining Key Performance Indicators (KPIs)

In this lesson, you learn to define Key Performance Indicators (KPIs) in your Analysis Services 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 (KPIs).

ms166548.note(en-us,SQL.100).gifNote:
A completed project through Lesson 6 is available by downloading and installing the samples. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

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

Concepts

Analysis Services Tutorial Scenario
SQL Server Analysis Services Tutorial

Other Resources

Key Performance Indicators (KPIs)

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker