Defining Dynamic Time Series Selections

You can select Dynamic Time Series (DTS) definitions for query selection statements.

DTS definitions must be created in Essbase before you can make DTS selections. You select the DTS definition and a corresponding Time dimension member that defines a time period.

You can select DTS substitution variables.

Substitution variables are predefined placeholders for information that changes frequently. Each substitution variable is identified by a variable name and has a temporary value defining its data type. When the substitution variable is used, the temporary value is replaced by a current value. For substitution variables to be used, they must be stored at the database level in Essbase.

  To define a DTS selection:

  1. Right-click a Time dimension member in the Dimension Browser, and select Dynamic Time Series.

    Available DTS definitions are displayed in a drop-down list.

  2. Select a DTS definition.

    The Dynamic Time Series dialog box is displayed.

  3. Perform one:

    • Select the Substitution Variable tab and select a substitution variable from the list.

    • Select the Member tab and select a dimension member representing the specified date in the "X-to-date" definition.

  4. Click OK.