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

Figure 40 Result of Remove Only (Navigate Without Data Enabled)

➤ To turn off Navigate Without Data when you are ready to retrieve data:

1 Select Essbase > Navigate Without Data.

Essbase removes the check mark next to the menu item.

You can also disable Navigate Without Data by clearing the appropriate option in the Essbase

Options dialog box (Global tab) or by clicking the Navigate Without Data button on the Essbase

toolbar.

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

Essbase drills down on the Market dimension and also retrieves data into the worksheet. The

result is shown in Figure 41.

Figure 41 Result of Drilling down (Navigate Without Data Disabled)

Note that if you want to retrieve data without changing the current worksheet view, you can also

retrieve data by simply double-clicking in any data cell or by selecting Essbase > Retrieve (after

disabling Navigate Without Data).

Suppressing Missing Values, Zero Values, and Underscore

Characters

Several types of data can be returned to a worksheet view:

● Numeric data values

● #NoAccess strings, which are displayed when you do not have the proper security access to

view a data value

● #Missing strings, which indicate that no data exists for that member intersection

Basic Tutorial

1 2 ... 47 48 49 50 51 52 53 54 55 56 57 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 52