Once the report is placed on a dashboard, the Member UniqueName
is dragged from the filter and dropped onto the report, and the Edit Filter Link
dialog box appears. All of the hierarchies are shown as possible endpoints, and the
developer can simply choose Product Categories and be done.
A more manual approach is for the developer to add Product Categories to the
Background box and then go to the Query tab where the MDX syntax for the query
is shown. Adding a dimension to the Background box adds a WHERE clause to the
MDX query. In this case, the added WHERE clause is
WHERE ([Product].[Product Categories].DEFAULTMEMBER)
The default member for almost any dimension is the All level.
The developer should highlight the text between the parentheses in the WHERE
clause. At the bottom, of the page is a Parameters panel. The developer should type
in a name for the parameter and then click the Insert button. If the parameter is
named ProdCat, for example, then
<
>
is inserted into the query.
Furthermore, the parameter ProdCat has a default value of
[Product].[Product Categories].DEFAULTMEMBER
which means the report will run even if no parameter value is supplied. Figure 5-38
shows what the query looks like with the parameter inserted.
134 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 publishing the report to the server, the developer returns to the dashboard
and drags the report from the Available Items into one of the zones.
Pages:
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194