Rearranging Dimensions within a Slice
For the succeeding examples, the objective is to configure the slice wherein the positions of the dimensions are as follows:
|
Dimension (Member/s) |
Page/ Filter |
Region (USA) |
Column |
Sales Account (All) |
Row |
Product (All) |
Re-arranging dimensions in a Default Slice view
This example will demonstrate how to rearrange the dimensions in the Default Slice view. To reconfigure the dimensions in the slice:
1. First, move Month dimension to Page. To do this, left-click and hold on the row label corresponding to Month dimension then drag and drop to Page section.
2. Next, move Product dimension to Rows. To do this, left-click and hold on the Page label corresponding to Product dimension then drag and drop to rows.
3. Press F9.
Re-arrange dimensions in a Traditional Slice view
This next example will demonstrate how to re-arrange the dimensions in the Traditional Slice view.
The difference of this particular slice view display is that the slice window is separated into two panes. The left hand pane, which is further divided into three parts: Page (or Filter), Column Labels and Row Labels list box, gives users the idea which Dimensions and corresponding members are actually displayed on the page, rows and columns. At the same time, it is in the left hand pane where users can move and reconfigure the positions of the dimensions in a slice. The right hand pane, on the other hand, is the grid which shows the actual values or figures that is contained in each data point.
To reconfigure the dimensions in the slice:
1. First, click and drag the Month dimension from the Row Labels list box to the Page or Filter list box
2. Next, drag and drop the Product dimension to Row Labels list box.
3. Press F9.