Time Dimension in Hyperion Essbase

Time Dimension:
When a dimension is tagged as "TIME", we get additional functions like Dynamic time series and also it "TIME" dimension enables several accounts dimensions properties. Select a dimension and select "TIME DIMENSION TYPE" button. Only one dimension in the outline can be tagged as time.

Dynamic Time Series:
Analytic services provide 8 pre-defined dynamic time series members.
H-T-D History-to-date
Y-T-D Year-to-date
S-T-D Season-to-date
P-T-D Period-to-date
Q-T-D Quarter-to-date
M-T-D Month-to-date
W-T-D Week-to-date
D-T-D Day-to-date

Dynamic time series members are not displayed as members in the database outline. Instead, analytic services lists the currently active Dynamic Time Series Members in a Comment on the time dimension.

To activate any of the dynamic time series members, right click on TIME dimension click dynamic time series. Another window appears. Select the required dynamic time series function, enter generation number under Gen column. Select Enable check box.

For y-t-d, select generation number for year, i.e. 2. For q-t-d, select generation number for quarter, i.e. 3. In order to retrieve the dynamic time series information, enter level zero member in brackets next to function Ex;y-t-d(jan2007) where jan2007 is level zero member.