Key Performance Indicators, Actions, and the DRILLTHROUGH Statement - Microsoft SQL Server 2008 Analysis Services - page 262

Now you create a KPI object using the user interface provided by BI Dev Studio by follow-
ing these steps:

1. In BI Dev Studio, open the FoodMart 2008 project.
2. In the Solution Explorer, double-click the Warehouse and Sales cube to open the
cube editor.
3. On the KPI tab, right-click anywhere in the KPI Organizer and choose New KPI from
the resulting menu.
4. Type the name of your KPI— Growth in Sales —in the Name text box.
5. Because this KPI analyzes data about sales, which is stored in the Sales measure
group, choose Sales from the Associated Measure Group drop-down list to associate
the KPI with the Sales measure group.
6. Copy and paste the Value , Goal , Status , and Trend MDX expressions into the corre-
sponding boxes of the KPI tab. Then, select the graphics to associate with the Status
and Trend indicators.

The KPI you created is a standalone KPI. Because the KPI isn't part of the scorecard, you
don't specify the ParentKpiID and Weight properties. Nor do you have to specify the
CurrentTimeMember property, but it's always a good idea to provide a detailed Description
property. Figure 15.2 shows the KPI tab filled out with the information given earlier.

When you deploy FoodMart 2008 project to the server, BI Dev Studio sends the DDL to
the server, which then alters the cube and saves the KPI object. Listing 15.5 shows the
portion of DDL related to the creation of the KPI.

FIGURE 15.2

You can use BI Dev Studio to create a KPI.