162 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
Note one problem with the grid: the width of the column holding the measure
names cuts off the word Margin for the Gross Profit Margin measure. The width
of the column cannot be adjusted, and this is true for both the developer during the
design phase and the user once the report is published to SharePoint. This is one
reason why the ProClarity tools or Excel are sometimes better tools for some of the
analysis.
Multiple Dimensions on Rows or Columns
Just as it is easy to display multiple measures on either the rows or columns, it is
easy to allow for multiple dimensions to be displayed on the rows or columns. In
a sense, Figure 6-20 showed this by having both the dates and measures on the
columns, but imagine now that the grid should show the gross profit by products by
sales territory in the rows and by time in the columns. Placing Gross Profit in the
background, Date.Date.Calendar on the Columns, and both Product Model Lines and
SalesTerritory on the Rows leads to such a report. When multiple dimensions are
placed on either the rows or the columns, the order in which they appear in the Rows
and Columns panels will determine the order in which they appear in the grid. In the
example of both products and sales territories being placed on the rows, if products
are first then products will show first, with sales territories indented slightly on the
next row.
Pages:
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224