In the query,
these columns are placed in the Columns clause in the query, but the Row clause
contains the dimension, hierarchy, and then the AllMembers function.
In MDX, the AllMembers function returns all members including calculated
members and the All member. If companies choose to remove the All member, the
query can be changed, replacing AllMembers with the Children function.
Adding Expansion Capabilities
One of the most powerful methods of reporting is to use the matrix control to allow
end users to examine lower levels of data in a report, using the rough equivalent
of the expansion functionality found in ProClarity. This can be accomplished by
adding multiple levels from the same dimension??”to either the rows or the columns.
The lower levels of detail are hidden by default and the end user can reveal them by
clicking a plus sign next to the higher level member.
332 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
In order to add additional levels, the developer has to add new row or column
groups to the matrix. An easy way to do this is by clicking on any cell in a matrix.
Once this is done, grey borders appear along the top and left side of the matrix. This
allows developers to select an entire row or column at a time to apply formatting.
Right-clicking on any of these row and column selectors opens a pop-up menu that
allows developers to add a column group or a row group.
Pages:
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422