1. Using Oracle Essbase
  2. Create and Manage Cube Outlines Using the Web Interface
  3. View and Edit Outline Properties for a Newly Created Cube
  4. Understand and Work With Dynamic Time Series Outline Properties

Understand and Work With Dynamic Time Series Outline Properties

To dynamically calculate period-to-date values, you can enable dynamic-time-series members for an outline. You must also associate the dynamic time series member with a generation member.

You use the Dynamic Time Series tab in the Outline Properties dialog box to enable and disable dynamic time series members, to associate dynamic time series members with generations, and to specify aliases for dynamic time series members. Your outline must contain a time dimension in order for you to work with dynamic time series members.

The Series column lists the eight system-defined dynamic time series members. See Using Dynamic Time Series Members:

  • H-T-D (history-to-date)
  • Y-T-D (year-to-date)
  • S-T-D (season-to-date)
  • P-T-D (period-to-date)
  • Q-T-D (quarter-to-date)
  • M-T-D (month-to-date)
  • W-T-D (week-to-date)
  • D-T-D (day-to-date)

To enable dynamic time series members:

  1. Go to Outline Properties.
    In the Redwood Interface:
    1. On the Applications page, open the application and then open the database (cube).
    2. Click Launch Outline.
    3. If the outline is locked, and you are an administrator, click Unlock outline Image of the Unlock outline icon in Redwood..

      Before you forcefully unlock a locked outline, make sure that no one else is working with it.

    4. Click Edit outline Image of the redwood edit outline icon in the outline editor..
    5. Click Outline properties Image of the outline properties icon in the redwood outline editor..
    In the Classic Web Interface:
    1. On the Applications page, expand the application.
    2. Click the Actions menu to the right of the cube name and click Outline.
    3. Click Edit.

      To view outline properties, simply click Outline Properties. You don't need to click Edit first.

    4. Click Outline Properties.
  2. Click Dynamic Time Series.
  3. Select or clear items in the Enabled column to enable or disable the member associated with the option.
  4. In the Generation column, select a generation number.

    You cannot associate dynamic time series members with level 0 members of the time dimension, and you should not assign a generation number to multiple members.

  5. (Optional) In the Default column, in the member row, enter one or more aliases (one each from one or more alias tables).