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

Figure 98 Essbase Unknown Member Message

In this example, the first unknown member detected is Market: (in cell A1). Essbase does not

recognize the colon (:) that follows Market in the cell. If you click Yes, Essbase displays the next

unknown member; if you click No, Essbase continues with the retrieval.

Note:

If you work with formatted worksheets often, you may want to configure Essbase so that this

message is not displayed. For information on configuring to avoid the Essbase message, see

“Pivoting Data on Formatted Worksheets” on page 107.

9 Click No to close the dialog box and continue with the retrieval.

Essbase retrieves new data but retains the formatting and formulas in the worksheet. The result

is shown in Figure 99.

Figure 99 Result of Retrieving on a Formatted Worksheet

10 Close the file without saving it.

Note:

The section on “Preserving Formulas When Retrieving Data” on page 109 provides additional

tutorial tasks that show you how to take advantage of all the Formula Preservation options.

Pivoting Data on Formatted Worksheets

Using the Pivot command, you can produce ad hoc reports in both formatted and unformatted

worksheets. A formatted worksheet, however, may contain labels and formulas that make the

result of a pivot operation ambiguous. The pivot is designed to compress and retain only the

Performing Advanced Retrieval Tasks

107

1 2 ... 102 103 104 105 106 107 108 109 110 111 112 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 107