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

11 Click OK.

12 Select Essbase > Retrieve.

Note:

The Retrieve & Lock, Zoom In, and Zoom Out commands are not supported with Dynamic

Time Series members.

Essbase displays data for the Q-T-D member, as shown in Figure 118. The data values in the

worksheet are the aggregated values for April and May, because May is the month that you

specified as the latest month in the quarter-to-date Dynamic Time Series.

Figure 118 Result of Specifying Latest Time Period in a Dynamic Time Series

13 To close the worksheet, select File > Close.

You do not need to save the worksheet.

In Advanced Interpretation mode, you can also create a report like the one shown Figure 118

by typing the name of the Dynamic Time Series member followed by the name of the latest time

period in parentheses (for example

Q-T-D(May)). If you are using Free-Form retrieval mode,

you must enter the Dynamic Time Series member enclosed in quotation marks (for example,

"Q-T-D") and the latest time period also enclosed in quotes (for example, ("May")) in separate,

adjacent cells. You can also select a Dynamic Time Series member and a latest time period

through Essbase Query Designer or through Member Selection.

For more information on Dynamic Time Series, see the Spreadsheet Add-in online help.

Using Substitution Variables

The Essbase application designer uses substitution variables to define global variables to

represent values that are specific to Essbase. For example, Latest can be a substitution variable

representing the latest time period in a Dynamic Time Series.

Using Essbase Administration Services Console, the application designer sets substitution

variables and their corresponding values for a specific application. Essbase stores these variables

and their values on the Essbase Server. You can take advantage of the predefined substitution

variables in Spreadsheet Add-in during Dynamic Time Series reporting.

For example, say the application designer sets a substitution variable on the server for the current

month. The variable is called CurMnth and has a value of August. If you use the substitution

variable in the worksheet, a retrieval returns values for August, because August is set as the

current month on the server. If, at a later date, the application designer changes the value of the

CurMnth substitution variable to October, a retrieval returns data for October.

Performing Advanced Retrieval Tasks

121

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 121