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).
To drill down to more detail:
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.
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.