LATEST

Specifies a Dynamic Time Series member in a report script, which has reserved generation names that are defined in the database outline alias table (You must create a Dynamic Time Series member in the database outline before you use it in a report script.)

If you use the < LATEST syntax, the command is applied globally in the report script. If you use the reservedName (mbrName) syntax, Essbase applies the command only to the member listed in the syntax argument.

Syntax

1:

<LATEST mbrName

2:

<LATEST reservedName (mbrName)

Parameters

reservedName

One of the following pre-defined generation names:

• History-To-Date (H-T-D)

• Year-To-Date (Y-T-D)

• Season-To-Date (S-T-D)

• Period-To-Date (P-T-D)

• Quarter-To-Date (Q-T-D)

• Month-To-Date (M-T-D)

• Week-To-Date (W-T-D)

• Day-To-Date (D-T-D)

mbrName

The name of the level 0 member in the Time dimension.

Notes

• You can create an alias table in the database and replace the predefined generation names with alias names.

• The "latest" period must be a level 0 member in the time dimension.

• Sparse retrieval optimization eliminates requested sparse members that do not have any data blocks in the database.

• You cannot use attributes as arguments.

Example

<LATEST May

or

Q-T-D (May)