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

database elements represented in the worksheet. The worksheet also retains labels in areas that

are not overwritten by pivoted data.

Note:

Essbase prevents pivot operations on worksheets that contain formulas when Formula

Preservation mode is active.

As part of the default Essbase installation, the

Inv.xls sample file is provided which illustrates

how to pivot data in a worksheet. The sample file was saved with the Retain on Retrieval option

disabled so that you can pivot on its worksheets.

➤ To view the Inv.xls worksheet:

1 Select File > Open.

2 From the \AnalyticServices\client\sample directory, open the Inv.xls file.

An example of this worksheet is shown in Figure 100.

Note:

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

located in a different directory. Contact the Essbase system administrator for the location of the

file.

Figure 100 Formatted Worksheet Before Pivoting

3 Select Essbase > Options and select the Global tab.

4 In the Display Messages group box, clear the Display Unknown Members check box to avoid seeing the

Essbase messages when working with formatted worksheets, and click OK.

5 Using the right-mouse button, drag Sales (in cell A5) to the cell nested below Jan (C4).

Essbase pivots the Sales member group so that it is nested below the monthly members. During

the pivot, however, Essbase retains only database elements. For example, all data for Stock to

Sales and Adjusted for Audit is deleted during the pivot.

The result is shown in Figure 101.

108

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 108