These buttons can be used to add the
selected member set to Columns, Rows, or Filters. For the purpose of the examples
in this chapter, the All Members member set of the Scenario dimension is added
to the Columns, the Corporate member set of the Entity dimension is added to the
Filters, the ExpenseAccount member set of Account dimension is added to the Rows,
and the YQM member set of Time dimension is added to the Columns, as shown
in Figure 7-37. If any dimension member set is added to the Filters, then the Select
Filters dialog box will appear to help the developer to pick the default members
for the filter dimensions. Select the value FIN for the Entity.Corporate filter for the
examples in this chapter.
The selected dimension member sets will appear in the Authoring pane at
this point. Clicking on the down arrow next to the name of each dimension will
open a pop-up menu with several options. The Select Members??¦ and the Select
Properties??¦ are the two most frequently used options here. The Select Members??¦
option will open the Select Members dialog box where the dimension members to
be displayed in the matrix are selected. The Select Members dialog box for the Time
dimension, along with the member selection used in the examples in this chapter,
is shown in Figure 7-38. The Select Properties??¦ option can be used to pick the
dimension properties to be displayed in the report matrix.
A single Excel work sheet in a multi-sheet report can contain multiple report
matrixes.
Pages:
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359