Data source types: Essbase, Planning, Oracle Planning and Budgeting Cloud Service, Financial Management, Hyperion Enterprise
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 Smart View release 11.1.2.5.400 and later, and requires Essbase and Provider Services 11.1.2.4 or later. |