Remember that this target is all sales, and
Adventure Works is mostly a company built to sell bicycles, so they determine that
Bikes should be at least 90% of total sales. Therefore, the actual for bikes can be
compared to either the actual sales or the quota, whichever the business determines
is the better approach (typically, business would use the actual sales and not the
quota in this case.) The thresholds, however, are set so that the indicator should
move to the On Target position at 90% or higher.
For this new target, a name such as Total or Percentage of Total can be used. An
indicator must be added as nothing comes up by default. Once the thresholds are set
and the data is mapped, returning to the scorecard now reveals additional items in
the Details pane. Figure 5-17 shows that while there is still just a single KPI of Sales
Amount, there are three Metrics: Bikes, Target, and % of Total.
These three metrics have been placed in the grid. The column labeled Bikes is
the Sales Amount measure filtered to show data for just the bikes category (which is
the majority of the data). The Target column would be the sales quota set for bikes;
in this case it is merely a hard-coded value of $30 million because there is not an
actual forecast for bikes in the cube. The threshold is set so that the current bike
sales of approximately $22.5 million are in the red, or Off Target, position. Finally,
the % of Total column represents the Sales Amount measure for all products.
Pages:
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163