Data source types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management, Oracle Enterprise Performance Reporting Cloud, Oracle Financial Consolidation and Close 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:
Single members or multiple members from the same dimension can be pivoted from the grid to the POV toolbar.
Single members or multiple members from the same dimension can be pivoted from the POV toolbar to the grid.
A single dimension, and even zero dimensions, can remain on the POV toolbar.
Note:
You can select only one dimension or one member at a time to pivot. In cases where multiple members from the same dimension are on the grid or POV, then all members in the dimension will be pivoted.
Essbase only: Multiple member pivot is supported from Oracle Smart View for Office release 11.1.2.5.400 and later, and requires Essbase and Oracle Hyperion Provider Services 11.1.2.4 or later.