Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 42)

Figure 21 Result of Drilling Up on East

Customizing Drill-Down and Drill-Up Behavior

You can customize the behavior of the Zoom In and Zoom Out commands in the Essbase

Options dialog box. The following steps illustrate some drill-down and drill-up techniques.

➤ To retrieve all members of a dimension with a single drill-down operation:

1 Select Essbase > Options and select the Zoom tab.

Essbase displays the Zoom Tab. A portion of the Zoom tab is shown in Figure 22.

Figure 22 Zoom In and Member Retention Option Settings

The Zoom In option group contains items that enable you to customize drilling behavior. You

can specify which members are returned to the worksheet during a drill-down operation. For

example, if you select Bottom Level, Essbase retrieves data for the lowest level of members in a

dimension. With this option, a drill-down on Year retrieves Jan, Feb, Mar, Apr, May, Jun, Jul,

Aug, Sep, Oct, Nov, and Dec.

The Member Retention option group contains items that enable you to customize drilling

retention characteristics. The default selection, Include Selection, retains the selected member

along with 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, as well as for Qtr1. When this option is

disabled, Essbase retrieves data only for Jan, Feb, and Mar; Qtr1 is eliminated.

For more information on the Zoom In and Member Retention option groups, see the

Spreadsheet Add-in online help.

2 In the Zoom In option group, select the All Levels option and click OK to save the setting.

3 In cell A3, drill down (double-click) on Market.

4 In cell C2, drill down (double-click) on Scenario.

Basic Tutorial

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 42