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

● “Retrieving Data into Formatted Worksheets” on page 105

● “Pivoting Data on Formatted Worksheets” on page 107

Observing the Rules for Working with Formatted Worksheets

Observe the following rules when retrieving data into a formatted worksheet:

Rule 1

In the worksheet, no numeric cells can be located before the first Essbase data cell. For example,

in Figure 97 on page 106, the first Essbase data cell is B6. Neither any cell in rows 1 through 5

nor cell A6 can contain numeric values. Also, these cells cannot contain formulas that resolve

to numeric values.

Rule 2

A cell that lies within a row or column of Essbase data cannot contain text or numeric values.

For example, in Figure 97 on page 106, the cells in columns B, C, D, and F and rows 6 through

9 and 11 through 14 cannot contain any nondata text or numbers, for such values may be

overwritten, or emptied, by the retrieved data. These cells can contain formulas, however, if

Formula Preservation options are used. For more information on Formula Preservation options,

see “Preserving Formulas When Retrieving Data” on page 109.

Tip:

If you need to preserve text in a cell, define that text or value as a spreadsheet formula, and use

the Formula Preservation options.

Rule 3

The Pivot command is not available when the Retain on Retrieval check box is selected in the

Mode tab of the Essbase Options dialog box.

Rule 4

The Pivot command removes all cells that contain text other than database member names.

Retrieving Data into Formatted Worksheets

As part of the default Essbase installation, the P&l.xls sample file is provided that illustrates

how to retrieve data into a formatted worksheet. The sample file illustrates how to retrieve data

into a worksheet that contains formatted text, formulas, and protected cells.

➤ To view the P&l.xls worksheet:

1 Select File > Open.

2 From the \AnalyticServices\client\sample directory, open the P&l.xls file.

An example of the worksheet is shown in Figure 96.

Performing Advanced Retrieval Tasks

105

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 105