Drilling down to more detail enables you to navigate down to lower levels in the multidimensional database.
You can specify which members are returned to the worksheet during a drill-down operation. The Zoom In option group contains items that enable you to customize drilling behavior. For example, if you select Bottom Level, Essbase retrieves data for the lowest level of members in a dimension.
The Member Retention option group contains items that enable you to customize drilling retention characteristics. The default selection, Include Selection, retains the selected member and the other members retrieved as a result of a drill down. For example, if you drill down on Qtr1, Essbase retrieves data for Jan, Feb, and Mar, and for Qtr1. When this option is disabled, Essbase retrieves data only for Jan, Feb, and Mar; Qtr1 is eliminated.
See also Zoom Page (Essbase Options Dialog Box).
Because spreadsheets can accommodate more rows than columns, Essbase retrieves data into rows, by default, when you drill down on a member.
To drill across columns, press Alt while double-clicking the member name you want to expand, and then release Alt.
Essbase expands the data into columns.
Drilling across columns applies only to top-level members of a dimension, also known as dimension or title members (for example, Products in Sample Basic).
If the spreadsheet contains spaces between rows, and you drill down on a member, Essbase mirrors the spaces in the resulting report.
You can drill down on shared members; however, the results that are retrieved depend on the report layout. See Drilling Down or Up On Shared Members.
Using Mouse Actions to Pivot, Retrieve, and Drill Up and Down