Change the display of data in a view

Dimensions can be moved to different positions in a view.

You can change the position of a dimension in a view by dragging the dimension tile and dropping it into a new position in the row, column, or context area. When you drag a dimension from the row or column area to the context area, the view focuses on that member.
Moving a dimension
Dimensions that are used as context can be visible in the view or can be placed on the bench to save space and to simplify the appearance of the view.
Moving a dimension to the bench
Note: If you move a dimension from a row or column to the context area, any filters, sorts, or keep, show or hide actions that have been applied to the dimension using the right click menu from the exploration view, are removed.

You can also use the Fields panel to manage settings for a view. All of the actions that are available in the overview area of a view are supported in the Fields panel, except Move to bench.

Procedure

  1. Create a book.
  2. Navigate to the GO_New_stores database, Base Sales Forecast cube in the tree, and add the All view to the book.
    This view has one dimension on the row axis, one dimension on the column axis, and four dimensions as context.
  3. Click and hold the Retailers dimension in the context area, then drop it next to the Month column dimension.
    You can drag a dimension from any location in a view to a different location. When you drop one dimension directly on top of another dimension, the positions of the dimensions in the view are switched. When you drop one dimension next to another dimension, both dimensions appear in the same location in the view.
  4. Click the menu icon next to a dimension to see Other move options.
    Depending on its position, you can move the dimension left or right, and to a row, column, or context.
    Other move options