Filters are created
independently of any scorecard or report.
132 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
Categories hierarchy, the KPIs listed on the Objectives Demo scorecard should not
include Product Categories as a filter in the design of the KPI itself.
Once the filter and scorecard are both placed on the dashboard, it is time to tie the
filter into the scorecard. Hovering over the filter in the design view will expand it
and one of the items listed is Member UniqueName. Member UniqueName is how
each member in a cube is uniquely identified; in other words, values like Bikes and
Clothing might not be unique across all dimensions if just the text is used, so there
is a unique value that identifies each member. Clicking on Member UniqueName
and dragging it will allow the designer to drag it and drop it on the scorecard. It
should be dropped in the area that says Drop Fields Here to Create Links. When the
Member UniqueName is dropped into the Drop fields here to create links area, the
Edit Filter Link dialog box appears and is on the Link Options tab. The Dashboard
item endpoint select box allows developers to select Filters, Row, or Column.
Normally, this should be set to Filters, unless the Product dimension is shown on
either the rows or columns. In the case of the AdvWorks??”Objectives scorecard,
the product is not shown anywhere so Filters should be chosen.
Pages:
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192