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

5 Select Essbase > Retrieve.

6 In cell B1, drill down on (double-click) Measures.

7 In cell B2, click Year.

8 Type Q-T-D in cell B2 and press Enter to enter a predefined Dynamic Time Series member (Q-T-D).

The result is shown in Figure 116.

Figure 116 Entering a Dynamic Time Series Member into a Worksheet

Note:

For a list of other possible Dynamic Time Series members, see the Spreadsheet Add-in online

help.

9 Select Essbase > Options and select the Display tab.

10 In the Dynamic Time Series group box, select the Latest Time Period check box and from the drop-down

list box, select May, as shown in Figure 117.

Figure 117 Specifying Latest Time Period in a Dynamic Time Series

Note:

If you do not specify a latest time period,Essbase uses the first level 0 member (Jan) as the default.

120

Advanced Tutorial

1 2 ... 115 116 117 118 119 120 121 122 123 124 125 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 120