Specifying Latest Period To-Date

Dynamic Time Series members are predefined members used in to-date calculations. Dynamic Time Series members do not appear as members in the database outline; instead, they represent a generation in a Time dimension. For example, in the Sample Basic database, the Application Designer can create a generation name called Quarter for generation 2 of the Year dimension containing the data for 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 calculations, you first define the latest time period for which you want data. The latest time period is the 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.

To specify the latest time period to use:

In Rules, select a Dynamic Time Series member (for example, Q-T-D).
Right-click and select Specify Latest.
In Select Latest Period, select a value from the list box.
The default selection is the first level 0 member in the list box.
Click OK.