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

Figure 30 Result of Pivoting the Order of Row Groups

In this example, notice that both the source cell and the destination cell are now members.

Whenever the source cell and the destination cell are members of different row groups, Essbase

exchanges the member groups. You must select a destination cell that contains a member name

to exchange row members. You can also exchange column members by choosing a destination

cell in another column that contains a member name.

Retaining a Data Subset

The Keep Only command retains only selected member rows or columns and removes all other

data from the worksheet view. This command provides a powerful way to remove dimensional

slices without having to delete individual cells.

➤ To keep only Actual and Budget data in the current worksheet:

1 In cell C2, select Actual, and in cell C3, select Budget, as shown in Figure 31.

Figure 31 Selecting Members for the Keep Only Command

2 Select Essbase > Keep Only.

Essbase removes the Variance, Variance%, and Scenario rows from the worksheet and retains

only Actual and Budget data, as shown in Figure 32.

Pivoting, Retaining, and Suppressing Data

1 2 ... 42 43 44 45 46 47 48 49 50 51 52 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 47