LATEST

The Essbase Report Writer LATEST command 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.)

Syntax 1

If you use the following syntax, the LATEST command is applied globally in the report script.

<LATEST mbrName

Syntax 2

If you use the following syntax, Essbase applies the LATEST command only to the member listed in the syntax argument.

<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

Q-T-D (May)