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

To disable Flashback:

1. Select Essbase > Options and click the Global tab.

2. Clear the Enable FlashBack check box.

Drilling Down to More Detail

You can drill down to various levels of multidimensional data in the worksheet. For example, if

you want to view data for a specific quarter or month rather than an aggregate data value for the

whole year, you can drill down on the Year dimension to see more detailed data.

You have three options for drilling down on a member:

● Select the member and select Essbase > Zoom In.

● Select the member and double-click the primary mouse button.

● Select the member and click the Zoom In button on the Essbase toolbar.

➤ To drill down to lower levels of the Year dimension:

1 On Year in cell A2, double-click the primary mouse button.

The drill-down action retrieves data for the level below (the children of) Year: Qtr1, Qtr2, Qtr3,

and Qtr4, as shown in Figure 15.

Figure 15 Result of Drilling Down on the Year Dimension

Note:

For a discussion of the relationships among Essbase database members, see “Database Outlines”

on page 17.

With Essbase, you can retrieve members into columns or rows that are grouped or nested. Row

groups containing more than one level of data are nested within single-member row groups. For

example, a row group containing Qtr1, Qtr2, Qtr3, and Qtr4 may be nested within a single-

member row for a specific region, such as East (see Figure 16). Drilling down to lower levels of

database members is one way to retrieve data into nested groups.

2 In cell D1, double-click to drill down on Market and create nested groups of rows down the worksheet.

Basic Tutorial

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 38