Database Reference
In-Depth Information
We talk more about making Excel reports in Chapter 15, but for now let's create a KPI for our cube in the
following exercise.
EXERCISE 11-4. ADDING A KPI TO YOUR CUBE
in this exercise, you add a KPi to the DWPubsSalesVer1 cube. once you have configured the KPi, we use the
browser feature that comes with Visual Studio to test a few titles.
Note:
if the solution from the previous exercise is closed, open Visual Studio. Remember to select Run as
Administrator and answer Yes to close the UAC.
Creating the KPI
1.
Navigate to the KPi tab of the cube designer window, as shown in Figure
11-46
.
2.
Click the New KPi button on the toolbar (circled in Figure
11-46
). This creates a new KPi.
3.
Change the name in the Name textbox to
SalesQty25to50KPI
, as shown in Figure
11-46
.
4.
in the “Associated measure group” dropdown box, select the Sales measure group
(Figure
11-46
).
5.
in the Value Expression textbox, type in
[Measures].[SalesQuantity]
, as shown in
Figure
11-46
.
6.
in the goal Expression textbox, type in
“Total Sales of at least 25 to 50 units”
(including the quotation marks), as shown Figure
11-46
.
7.
Under the “Status indicator,” select the road signs icon using the dropdown box
(Figure
11-46
).
8.
in the “Status expression” textbox shown in Figure
11-46
, type in the MDX
expression indicated in Listing 11-5.
Listing 11-5.
Grouping KPI Values into Three Categories
case
when [SalesQuantity]<25 or null then -1
when [SalesQuantity]>= 25 and [SalesQuantity]<= 50 then 0
when [SalesQuantity]>50 then 1
end
Process the Cube
1.
Right-click the cube in Solution Explorer, and select Process from the context menu.
This builds, deploys, and processes your cube and sends the changes for your new
KPi to the server.
2.
Complete the processing step and close all the dialog boxes when it has completed.
