274 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
and Start in Cell: text boxes. The value entered in the Start in Cell: box determines
the location of the report matrix within an Excel worksheet. Space can be provided
in the Excel worksheet for customized report titles by appropriately selecting
the matrix start cell. The Model: box lists all the models available in our Budget
application. Highlight the CorpBudget from Budget to select the CorpBudget model
for the purpose of the examples in this chapter. The Options tab in the New Matrix
dialog box allows the developer to select the various report matrix options, including
allowing data entry, removing blank rows and columns, and so on. The selections on
this tab are left at their default values. Clicking OK will close the dialog box, and the
new matrix??”Matrix1??”will appear in the Authoring pane, as shown in the right half
of Figure 7-36.
The next step in creating a report matrix is selecting the dimensions for the
matrix. After highlighting Matrix1 in the top box, pick Select Dimensions from
the Available Actions drop-down box. Clicking on the green arrow button next to
the drop-down box will open the Select Dimensions for Matrix dialog box. All the
dimension member sets used in the model CorpBudget are available on the left side
of this dialog box. Selecting a member set from any dimension will enable the three
buttons in the middle bar of the dialog box.
Pages:
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358