O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating KPIs

Key performance indicators (KPIs) have captured the attention of the business world in recent years. A KPI measures the progress that a business is making toward meeting its goals. In Analysis Services, a KPI provides a visual representation of these comparative metrics over time, rather than just displaying the numbers. The visual representation is based on your input and shows whether the progress against goals is positive, neutral, or negative by using graphical images such as a stoplight that displays a green, yellow, or red light according to the specified business rules.

You create a KPI in the Cube Designer. For each KPI, you develop expressions that calculate the KPI’s value, goal, current status, and trend. The Value expression ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required