O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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 Key Performance Indicators

You can create key performance indicators (KPIs) in SSAS cubes using MDX code using the KPIs tab, as you’ve seen in Chapter 8, and then you can use those KPIs in client tools such as Microsoft Office Excel 2007 or PerformancePoint Server 2007. Because MDX code is the basis for KPIs, let’s take a look at a basic KPI. Here you’ll use calculated members as part of your KPI definition.

The Adventure Works database tracks a measure called Total Product Cost. Suppose you want to evaluate the trend in Total Product Cost. First you need a calculated member that determines Total Product Cost for the previous period based on the current period. Figure 11-18 shows a calculated member that slices Total Product Cost to the ...

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