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

<LATEST mbrName

<LATEST reservedName (mbrName)

Parameter	Description
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.

Parameter

Description

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)