Cloud data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud
On-premise data source types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning
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.
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.