Pivoting dimensions

You can pivot the dimensions in your Cube Viewer to change the presentation of cube data. To pivot dimensions, use the drag-and-drop operation.
  • Drag a dimension to the column position.
  • Drag a dimension to the row position.
  • Drag a dimension to the title position.

When you drag a dimension to a new position, three possible options are available when you drop the dimension. The options vary by the position of your cursor. The following examples use dimensions named Dimension1 and Dimension2.

  • When you drag Dimension1 and position your cursor in the center of Dimension2, dropping the dimension will swap the positions of the two dimensions.
    Illustration shows indicators that appear when swapping Dimension 1 with Dimension 2.
  • When you drag Dimension1 and position your cursor on the left side of Dimension2, Dimension1 is dropped immediately to the left of Dimension2.
    Illustration shows indicators that appear when dropping Dimension 1 before Dimension 2.
  • When you drag Dimension1 and position your cursor on the right side of Dimension2, Dimension1 is dropped immediately to the right of Dimension2.
    Illustration shows indicators that appear when dropping Dimension 1 after Dimension 2.

If you drag a dimension and drop it immediately to the left or right of an existing column or row dimension, you can see more detail along the columns or rows of a view.