Returns period-to-date values.
xTD ( [member ] )
| xTD |
Values:
|
||||||||||||||||
| member | Member specification. Should be a member from the time dimension. |
xTD ( [member ] ) is equivalent to PeriodsToDate ( layer, [member])
where layer is assumed to be the value set in the corresponding Dynamic Time Series
member in the database outline.
For example, in Sample Basic, QTD ([member]) is equivalent to
PeriodsToDate ( Year.Generations(2) [,member]), because
Q-T-D is Generation 2 in the Year dimension.
You can use the PeriodsToDate function with aggregate storage databases in place of the xTD functions.
For example,
YTD(May)is equivalent toPeriodsToDate(Year.Generations(1), May)
QTD(May)is equivalent toPeriodsToDate(Year.Generations(2), May).
QTD([Feb])
returns the set{[Jan], [Feb]}.
QTD([Feb])is equivalent toPeriodsToDate([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 toPeriodsToDate([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 |