Figure 5-11 Two different levels of the Product Model Lines hierarchy are displayed in the
scorecard. Note that dimensions can be added to both the rows and columns
of a scorecard and include members from various levels.
98 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
After the KPI or objective has been created, it is added to the KPIs folder in the
Workspace Browser. Clicking on the new KPI in the Workspace Browser opens
up the two tabs in the main work area: Editor and Properties. The Properties tab is
the same as the one for both scorecards and data sources so there is nothing unique
about how it works. The Editor tab, however, presents designers with the ability to
modify the name, actual value, target value, how it is displayed, how the thresholds
are set, and what indicator is used.
Figure 5-12 shows the dialog box that is displayed for the Number Format for
a KPI. If the developer chooses to override the default display format, there are
options to set a variety of parameters regarding the display. The number of decimal
places to show can be set from 0 to 30. The multiplier is useful when the data is
stored in the cube as a decimal but represents a percentage; for example, if a gross
margin measure is stored as .12, the multiplier could be set to 100 and a percentage
sign could be added in order to make it show up as 12% in the scorecard. Hardcoded
symbols can be placed on the left and right sides of the value, allowing for
Figure 5-12 When editing a KPI, the number format can be set manually.
Pages:
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152