<LATEST

Command

The LATEST command specifies a Dynamic Time Series member in a report script. You must create a Dynamic Time Series member in the database outline before you use it in a report script.

Syntax

<LATEST mbrName

reservedName (mbrName)

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.

Description

This command specifies a Dynamic Time Series tag, which has reserved generation names that are defined in the database outline alias table. If you use the < LATEST syntax, the command is applied globally in the report script. If you use the reservedName (mbrName) syntax, Hyperion Essbase applies the command only to the member listed in the syntax argument.

Example

<LATEST May

Q-T-D (May)

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.

See Also

Database Administrator's Guide

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.