Note that a scorecard could have both kinds of KPIs
but the wizard does not give designers a method for mixing and matching those. That
will have to be done later by manually editing the scorecard. The approach that will
be discussed in the following paragraphs is the one in which new KPIs are created in
the Dashboard Designer based on measures in the cube.
If you choose to create the KPIs in Dashboard Designer, you??™ll see that the screen
for adding KPIs to the scorecard has two buttons: Add KPI and Select KPI. Select
KPI allows you to choose KPIs already created in the workspace or on the server.
If there are no existing KPIs, the developer must choose the Add KPI button, which
begins the process of defining a KPI.
When the Add KPI button is clicked, the first measure in the cube is added by
default. The Name column is filled in with the measure name, the Actual and Targets
are both set to the cube measure, and the Band Method is set to Increasing is Better.
C h a p t e r 5 : M o n i t o r i n g i n P e r f o r m a n c e P o i n t S e r v e r 93
The Targets column contains a drop-down list of all the measures in the cube, but the
developer can also type in a hardcoded value if one exists. Obviously, formulas can
be placed in here as well, which will be discussed later.
The Adventure Works DW sample database is being used in the examples shown
in the screenshots. Two of the measures in the Adventure Works cube are called Sales
Amount and Sales Amount Quota, and these two measures will work nicely as the
Actual and Targets respectively.
Pages:
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146