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

➤ To preserve formulas when retrieving or retaining data:

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

2 Select Essbase > Retrieve.

3 In cell A2, drill down (double-click) on Year.

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

5 Select cell G3 and enter the following formula in the cell: =B3/B$7*100, as shown in Figure 102.

The $ in front of the 7 anchors the formula to the Year member.

Figure 102 Entering a Formula into a Cell

6 Press Enter.

The spreadsheet calculates the formula that you entered in cell G3 and now reflects Qtr1 as a

percentage of Year. The result is shown in Figure 103.

Figure 103 Result of Calculated Formula with Essbase Data

7 Select Essbase > Options and select the Mode tab.

8 In the Formula Preservation group box, select the check boxes for Retain on Retrieval and Retain on Keep

and Remove Only, and click OK.

9 In cells D2, E2, and F2, respectively, select Variance, %Variance, and Scenario.

10 Select Essbase > Remove Only.

Essbase removes the selected columns but retains the formula that you entered, keeping it with

the retained dataset. The result is shown in Figure 104.

110

Advanced Tutorial

1 2 ... 105 106 107 108 109 110 111 112 113 114 115 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 110