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