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

You do not need to save the worksheet.

Pivoting, Retaining, and Suppressing Data

After you retrieve data into the worksheet, you may want to manipulate the data in various ways.

For example, you may want to move rows and columns to different positions in the worksheet,

or you may want to tell Essbase to suppress or to retain specific data during data retrievals.

To help you manipulate worksheet data, this section steps you through the following procedures:

● “Pivoting Rows and Columns” on page 44

● “Retaining a Data Subset” on page 47

● “Removing a Data Subset” on page 49

● “Navigating Through the Worksheet Without Retrieving Data” on page 49

● “Suppressing Missing Values, Zero Values, and Underscore Characters” on page 52

Pivoting Rows and Columns

With the Pivot command, you can change the orientation of worksheet data. Use the Pivot

command to perform any of the following tasks:

● Move a row group to a column group

● Move a column group to a row group

● Change the order of row groups

● Change the order of column groups

You can execute the Pivot command in two ways:

● Select the member cell that you want to pivot, and select Essbase > Pivot. This method applies

only to moving a row group to a column group or a column group to a row group.

● Click in the center of the member cell that you want to pivot, press and hold down the

secondary mouse button, and drag the group to the desired location. This method applies

to swapping row and column groups and to changing the order within groups.

➤ To pivot Year data from a row group to a column group:

1 Select File > New or click to open a new worksheet.

Note:

You should already be connected to the Sample Basic database. If you are not connected, follow

the steps in “Connecting to a Database” on page 33.

2 Select Essbase > Retrieve.

3 Drill down (double-click) on Measures and Product (in cells B1 and C1, respectively).

4 Press and hold down the Alt key, and, in cell E1, drill down (double-click) on Scenario.

Basic Tutorial

1 2 ... 39 40 41 42 43 44 45 46 47 48 49 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 44