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

● Zero data values

A missing value is not the same as a zero value that is loaded into the Essbase database. When

data does not exist for a data cell in Essbase, a value of #Missing is returned to the worksheet. If

any cell in a row contains a value, that row is not suppressed on a retrieval.

Using Essbase, you can suppress missing and zero values from the display in the worksheet. In

addition, you can tell Essbase to suppress underscore characters that are in some member

names.

➤ To suppress rows that contain missing values from being displayed in the worksheet:

1 In cell C3, double-click the secondary mouse button to drill up on Profit.

2 Pivot Measures (in cell C3) to Actual (in cell D1).

3 In cell B4, drill down (double-click) on product 100.

In the South member group, the product 100-30 row contains all missing values, indicating that

this product is not sold in the South, as shown in Figure 42. You may need to scroll down the

worksheet to see this row.

Figure 42 Worksheet View Displaying Missing Data Values

4 Select Essbase > Options, and select the Display tab.

5 In the Suppress option group, select the #Missing Rows check box and click OK.

The Suppress #Missing Rows and Zero Rows options are not available when any of the Formula

Preservation options are selected in the Mode tab of the Essbase Options dialog box.

For more information on Formula Preservation, see “Preserving Formulas When Retrieving

Data” on page 109.

6 Select Essbase > Retrieve to update the worksheet.

Note:

After you change a worksheet option in the Essbase Options dialog box, you must perform a

retrieval or drill operation to put the new setting into effect.

Pivoting, Retaining, and Suppressing Data

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 53