Selecting Dynamic Time Series Members

You create and identify dynamic members in the database outline; they are members calculated only during user retrieval requests, such as generating a report script. The time dimension has a special Dynamic Time Series option. The Dynamic Time Series option has reserved the following generation names that you can define in the outline alias table, as listed in Table 105:

Table 105. Dynamic Time Series: Reserved Generation Names

Generation Name

Reserved Names

Explanation

History

H-T-D

History-to-Date

Year

Y-T-D

Year-to-Date

Season

S-T-D

Season-to-Date

Period

P-T-D

Period-to-Date

Quarter

Q-T-D

Quarter-to-Date

Month

M-T-D

Month-to-Date

Week

W-T-D

Week-to-Date

Day

D-T-D

Day-to-Date

See Applying Predefined Generation Names to Dynamic Time Series Members.

Note:

The database header message for the outline identifies the number of dynamic members that are enabled in the current outline.

  To select a Dynamic Time Series member, at the point in the script where you want to select a Dynamic Time Series member, use either:

When you run the report script, the members are dynamically updated and the information is incorporated into the final report.

Note:

You must enter the Dynamic Time Series string exactly as it is displayed in the database outline; you cannot create a string and incorporate it into the final report. You can create an alias table for the Dynamic Time Series members in the database outline and use the aliases instead of the predefined generation names.