Essbase offers enhanced mouse actions in Excel. You can use the mouse to perform these tasks:
Drill down and drill up on database members
Pivot (move or transpose) data rows and columns
To execute a pivot, you must press the secondary, rather than the primary, mouse button while dragging the selection.
Access linked reporting objects
Access linked partitions
To enable double-clicking to retrieve, drill down, and drill up on Essbase data:
Select Essbase, and then Options.
On Global, select Enable Double-Clicking.
When Enable Double-Clicking is selected, you can retrieve and drill down to more detailed data (primary mouse button) and drill up to less detailed data (secondary mouse button). When double-clicking is enabled, the in-cell editing feature is overridden.