Once again, the
Member UniqueName is dragged from the filter and dropped into the Drop fields
here area of the report. The Edit Filter Link dialog appears. This time, however,
when the developer drops down the Dashboard item endpoint list, the items that
appear are the dimensions specifically added to the background, series, or bottom
axis, meaning that the name of the parameter added will not show up. In this case,
the developer would choose Product Categories. After clicking the OK button, the
report is now tied to the parameter.
In this case, a filter, a report, and a scorecard have all been added to a dashboard,
and the filter has been connected to the report and the scorecard. The process is
basically the same for the scorecard and report, but the scorecard did not need any
special steps. In contrast, the report may have its query modified so that the WHERE
clause contains the name of a parameter created for that report, although this step
is not necessary. Given that this step is optional and entails extra work, the primary
reason for doing it is to make the MDX clear to anyone viewing it in the future that
it is specifically designed to accept a filter when on a dashboard.
Figure 5-38 Replacing the background filter of a report query with a parameter allows
the report to be linked to a dashboard filter.
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 135
At this point, it is a simple matter of publishing the dashboard and then exporting
it to SharePoint.
Pages:
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195