Specifying Latest Time Period for Dynamic Time Series

Dynamic Time Series members are predefined members used in to-date reporting. Dynamic Time Series members do not appear as members in the database outline; instead, they correspond to a generation in a Time dimension. For example, in the Sample Basic database, you can create a generation name called Quarter for generation 2 in the Year dimension containing the members Qtr1, Qtr2, Qtr3, and Qtr4. When you create the generation name Quarter, Essbase creates and enables a Dynamic Time Series member called Q-T-D.

To use Dynamic Time Series in reports, you first define the latest period for which you want data. The latest period is a level 0 member in a Time dimension. In the Sample Basic database, the level 0 members 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, Dynamic Time Series calculation gives you the sales data for the months of July and August.

Table 2 lists Dynamic Time Series by generation name.

Table 2. Dynamic Time Series

Dynamic Time Series	Generation Name
H-T-D	History
Y-T-D	Year
S-T-D	Season
P-T-D	Period
Q-T-D	Quarter
M-T-D	Month
W-T-D	Week
D-T-D	Day

Notes:

The availability of the Dynamic Time Series member depends on what generation names you defined in the outline.
The Application Designer can create alias names for the predefined time series members.

To specify the latest time period to use in spreadsheet retrievals:

Create a spreadsheet report using a predefined Dynamic Time Series member.

Note:

In Advanced Interpretation mode, you can create a report 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 adjacent cells. You can also select a Dynamic Time Series member and a latest time period through Query Designer or through Member Selection.

Select Essbase, and then Options.
In Essbase Options, select Display.

Under Dynamic Time Series, select Latest Time Period and select one of the level 0 members of the Time dimension listed.

Note:

If the spreadsheet contains a Dynamic Time Series member, Essbase places the latest time period in parentheses next to the Dynamic Time Series member. For example, if you selected May as the latest time period, the spreadsheet displays Q-T-D(May).

Click OK.
Select Essbase, and then Retrieve.
Note:
Spreadsheets containing Dynamic Time Series members are not supported with the Retrieve & Lock, Zoom In, and Zoom Out commands.