To use pre-defined Dynamic Time Series (DTS) members to dynamically calculate period-to-date values, you must enable them for an outline. When you enable a DTS member, you must associate the DTS member with a generation number.
When you associate a DTS member with a generation number, Essbase creates a predefined generation name for the generation number. Predefined member and generation names are reserved for use by Essbase. If you create a generation name on the time dimension, and you use one of the predefined generation names, Essbase automatically creates and enables the corresponding DTS member for you.
Note: | Dynamic time series members do not apply to aggregate storage databases. |
To enable a Dynamic Time Series (DTS) member in an outline:
Select Outline, then Dynamic time series.
Outline Editor displays the Define Dynamic Time Series Members dialog box.
In the Enabled column, select the check box for the pre-defined DTS member that you want to enable.
In the Gen column, select the generation with which you want to associate the member that you selected to be enabled.
When you click a cell in the Gen column, a drop-down list is displayed. The list identifies the numbers of the generations within which you can create a DTS member in the current outline.
If desired, you can create an alias name for the DTS member. See Creating Aliases for Dynamic Time Series Members.
Click OK.
“Selecting Dynamic Times Series Members” in the Oracle Essbase Database Administrator's Guide
“Using Dynamic Time Series in Partitions” in the Oracle Essbase Database Administrator's Guide