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

Figure 115 Result of Retrieving Dynamic Calculation Members

Note:

Occasionally, other styles that you have set will override a style for dynamic calculation members.

For example, if a parent member is also a dynamic calculation member, and if you have set styles

for both parent and dynamic calculations, the style for the parent member overrides the style

for the dynamic calculation member. You must remove the style for parent members in order

to see the style for dynamic calculation members. For more information on the precedence of

styles, see “Precedence of Overlapping Styles” on page 59.

13 Close the Asymm.xls file without saving it.

Specifying the Latest Time Period for Dynamic Time Series

Dynamic Time Series members are predefined database members that are used in dynamic, to-

date reporting, such as year-to-date or month-to-date values. Dynamic Time Series members

are not displayed as individual members in the database outline; instead, they correspond to a

generation name that uses a key term for time, such as year, month, or day.

For example, in the Sample Basic database, a generation name called Quarter was created for

generation 2 in the Year dimension. Generation 2 includes the members for Qtr1, Qtr2, Qtr3,

and Qtr4. When the generation name Quarter was created, Essbase created a Dynamic Time

Series member called Q-T-D, or quarter-to-date.

To take advantage of Dynamic Time Series in Spreadsheet Add-in, choose the latest time period

for which you want data in a to-date calculation. The calculated value of the Dynamic Time

Series member is derived when you define the latest time period to be reported.

In the Sample Basic database, for example, the level 0 members of the Year dimension are the

months of the year: Jan, Feb, Mar, and so on. If the current month is August and you want to

know the sales data for the quarter up to the current month, a quarter-to-date calculation gives

you the sales data for the months of July and August.

➤ To illustrate the concept of Dynamic Time Series:

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

2 Select Essbase > Options and select the Zoom tab.

3 In the Zoom In option group, select Next Level.

4 Clear the Within Selected Group check box and click OK.

Performing Advanced Retrieval Tasks

119

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 119