Pivoting Dimensions or Members between the Grid and the POV

You can select to pivot a dimension out of the ad hoc grid to the Point of View (POV), or out of the POV to the grid. You can also pivot a member. When you pivot a member, the other members in its dimension are also pivoted.

Pivoting a Dimension from the Grid to the POV

To pivot a dimension from the grid to the POV:

1. Select the dimension in the grid.

2. From the provider ad hoc ribbon, in the Analysis section, click the arrow under Pivot, and then select Pivot to POV.

3. Open the POV panel. To do so, from the provider ad hoc ribbon, in the Data section, click POV.

   The dimension is displayed in the POV panel.

Pivoting a Dimension from the POV to the Grid

To pivot a dimension from the POV to the grid:

1. Open the POV panel.

   From the provider ad hoc ribbon, in the Data section, click POV.

2. To pivot a dimension from the POV to a column in the grid:

   In the POV panel, click the ellipsis button to the right of the dimension, and then select Pivot to Column.

3. To pivot a dimension from the POV to a row in the grid:

   In the POV panel, click the ellipsis button to the right of the dimension, and then select Pivot to Row.

Pivoting a Member from the POV to the Grid

To pivot a member from the POV to the grid:

1. Open the POV panel.

   From the provider ad hoc ribbon, in the Data section, click POV.

2. Ensure that you have added members to the drop-down list by completing the procedure in Selecting Members from a Point of View Dimension.

3. Click the drop-down arrow for the dimension to view the list of available members, and select a member from the list.

   For long member lists, you can filter members by typing part of the member name in the dimension text box. For example, using the Vision Product dimension, begin typing Computer. The drop-down list filters on members with Computer in the name:

   

4. To pivot the selected member from the POV to a column in the grid:

   In the POV panel, click the ellipsis button to the right of the dimension, and then select Pivot to Column.

5. To pivot the selected member from the POV to a row in the grid:

   In the POV panel, click the ellipsis button to the right of the dimension, and then select Pivot to Row.

Guidelines on Pivoting Dimensions and Members

Consider the following guidelines while pivoting:

• You can leave any number of dimensions in the POV.
• After pivoting the last dimension from the POV to the grid, the POV panel is hidden. You can always reopen the POV panel to display it again.

• The grid must always contain at least two dimensions: one row dimension, and one column dimension. When there is only one row dimension and one column dimension on a grid, you must first pivot the replacement dimension on to the grid before you can pivot a dimension out of the grid.

  For example, if you want to pivot the row dimension off of the grid, then you must first pivot the replacement row dimension on to the grid, and then pivot the unwanted row dimension off of the grid.

• When you pivot a member from the grid to the POV, the member selected on the grid becomes the POV for that dimension. For example, if you pivot Qtr2 of the Year dimension from the grid to the POV, then Qtr2 becomes the POV for the Year dimension.

• You can manually type a dimension or member name to replace a dimension or member name in the grid or the POV.

  Similarly, you can delete a dimension or member from the grid, refresh the grid, and the deleted dimension or member is moved from the grid and will display on the POV.

• You can pivot members by selecting them from the POV, as described in Selecting Members from a Point of View Dimension.