Pivot
Change the point of view of a dimension.
Availability
Features | Microsoft | |||||||
---|---|---|---|---|---|---|---|---|
Essbase | SSAS | Planning | PBCS | Essbase | SSAS | Planning | PBCS | |
Pivot | ✅ | ✅ | ❌ | ✅ | ✅ | ✅ | ❌ | ❌ |
Pivot to POV | ✅ | ❌ | ❌ | ✅ | ✅ | ❌ | ❌ | ❌ |
How to access the feature
In the applications tab toolbar, Pivot is the second option from the right.
How to use the feature
You have to highlight the cell containing the dimension or member you want to pivot and then click pivot.
The target will be pivoted to be either on the vertical or horizontal as opposite to where it was before.
The sub-action Pivot to POV can be used to pivot the member directly to the user point of view.