xTD

Returns period-to-date values.

Syntax

xTD ( [member ] )

xTD Values:
HTD History-To-Date (H-T-D)
YTD Year-To-Date
STD Season-To-Date
PTD Period-To-Date
QTD Quarter-To-Date
MTD Month-To-Date
WTD Week-To-Date
DTD Day-To-Date
member Member specification. Should be a member from the time dimension.

Notes

Examples

QTD([Feb])
returns the set {[Jan], [Feb]}.

QTD([Feb]) is equivalent to PeriodsToDate([Year].Generations(2), [Feb]), because the dynamic-time-series member Q-T-D is defined as Generation 2 of the Year dimension.
HTD([May])
returns the set {[Jan], [Feb], [Mar], [Apr], [May]}.

HTD([May]) is equivalent to PeriodsToDate([Year].Generations(1), [May]), because the dynamic-time-series member H-T-D is defined as Generation 1 of the Year dimension.

Note: If a dynamic-time-series member is not defined, an empty set is returned.

PTD([Feb]) 
returns an empty set, because the dynamic-time-series member P-T-D is not enabled in the outline.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com