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 |