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

Essbase suppresses product 100-30 from the South member group, as shown in Figure 43.

Figure 43 Result of Suppressing Missing Data Values

7 Select File > Close to close the worksheet.

You do not need to save the worksheet.

After you enable the Suppress #Missing Rows feature in the Essbase Options dialog box, any

missing values suppressed during a data retrieval are not retrieved again by disabling the feature.

If you disable the feature in the Essbase Options dialog box, missing values are retrieved from

only that point on. For example, in this tutorial task, Essbase could not go back and return the

missing values for product 100-30. To return these missing values to the worksheet, you disable

the Suppress #Missing Rows feature, drill up on a Product member, and then drill down again.

You can also suppress zeros and underscore characters as described in this tutorial task by

clicking the appropriate options in the Suppress option group in the Essbase Options dialog box

(Display tab).

In addition to suppressing specific values and characters during retrieval, Essbase enables you

to define a label for missing values (#Missing) or for data to which you do not have access

(#NoAccess). If you define a replacement label for these values, Essbase displays the replacement

labels instead of the default labels. For more information on defining replacement labels for the

#Missing and #NoAccess labels, see the Spreadsheet Add-in online help.

Formatting the Worksheet

Essbase provides you with various ways to customize the worksheet view. For example, you may

want to apply visual cues, or styles, to certain member names or to data cells in the worksheet.

You may want to display alternative names, or aliases, for member names. This topic steps you

through the following formatting procedures:

● “Formatting Text and Cells” on page 55

● “Displaying Aliases for Member Names” on page 61

● “Displaying Both Member Names and Aliases” on page 62

● “Repeating Member Labels” on page 63

Basic Tutorial

1 2 ... 49 50 51 52 53 54 55 56 57 58 59 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 54