User`s guide

➤ 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