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

Note:

Depending on how software is installed on your machine, the file may not be available or may

be located in a different directory. Contact the Essbase system administrator for more

information.

Figure 97 A Sample Formatted Worksheet

3 Select Essbase > Options and select the Display tab.

4 In the Cells option group, make sure that Adjust Columns is checked.

5 Select the Mode tab.

6 In the Formula Preservation group, select the Retain on Retrieval check box to enable Formula Preservation

mode.

Note:

When Retain on Retrieval is selected, there may be a slight delay in retrieval time.

7 Click OK.

By default, an Essbase retrieval overwrites the spreadsheet formula with data values in the

retrieval area of a worksheet. The retrieval process also eliminates formulas in cells outside the

retrieval area. The Retain on Retrieval option, however, enables you to define retrievals that do

not overwrite formulas in any area of the worksheet.

8 Select Essbase > Retrieve to update the worksheet with the latest data values.

Essbase determines that some text cells in the worksheet do not correspond to database member

names. When Essbase is unable to resolve text in the worksheet, the message shown in

Figure 98 is displayed:

106

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 106