Enabling Mouse Actions

Essbase offers enhanced mouse actions in Excel. You can use the mouse to perform these tasks:

Retrieve data
Drill down and drill up on database members
Pivot (move or transpose) data rows and columns
Note:
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.
Click OK.