1. Working with Oracle Smart View for Office
  2. Ad Hoc Analysis
  3. Pivoting

Pivoting

Pivoting changes the orientation of the data on the worksheet. You can move dimensions between rows and columns and between the grid and the POV.

Data source types: Oracle Essbase, Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Tax Reporting

Additionally:

  • One or more dimensions can be pivoted from the grid to the POV toolbar.

  • One dimension at a time can be pivoted from the POV toolbar to the grid.

  • A single dimension, and even zero dimensions, can remain on the POV toolbar.

  • You can select only one dimension or one member at a time to pivot between rows and columns on the sheet. In cases where multiple members from the same dimension are on the grid, then all members in the dimension will be pivoted.

  • 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 pivot Qtr2 of the Year dimension from the grid to the POV, then Qtr2 becomes the POV for the Year dimension.