Using the Dimension Controller

In the Dimension Controller dialog box, you can rotate dimensions within the view. Dimensions can be rotated only if the administrator allowed rotation for the view. For Analysis Services applications, even virtual dimensions can be rotated.

The current on-grid dimensions display at the top.

You can click and drag dimensions from the grid to the dimension list at the bottom or vice versa. This gives you a variety of options for changing the grid.

To exchange on-grid dimensions, click on a dimension and drag it over the top of another on-grid dimension.

To add a dimension to the grid, click on a dimension from the Dimensions column and drag it to the on-grid dimensions area. The point of insertion is highlighted.

To remove a dimension from the grid (assuming there is at least one dimension left on each axis of the grid), drag it from the grid to the same-named dimension in the dimension list.