Database Reference
In-Depth Information
FuNCTIoN
uSE
FirstMinute
Specifies the first minute in an hour, day, or larger time
period.
LastMinute
Specifies the last minute in an hour, day, or larger time
period.
FirstSecond
Specifies the first minute in a minute, hour, or larger time
period.
LastSecond
Specifies the last minute in a minute, hour, or larger time
period.
Period-to-Date Formulas
PerformancePoint 2010 introduced period-to-date formulas in order to provide
a way to aggregate data up to the last completed period requested. These
formulas will exclude incomplete time periods and use the lowest time pre-
cision supported by the underlying data source. The period-to-date periods
shown in Table 7-6 may be used within TI formulas.
TABle 7-6
Period-to-Date Formulas
PErIoD
uSE
YearToDate
Specifies a time period from the beginning of the year to
the current period.
QuarterToDate
Specifies a time period from the beginning of the quarter
to the current period.
MonthToDate
Specifies a time period from the beginning of the month
to the current period.
WeekToDate
Specifies a time period from the beginning of the week to
the current period.
DayToDate
Specifies a time period from the beginning of the day to
the current period.
HourToDate
Specifies a time period from the beginning of the hour to
the current period.
MinuteToDate
Specifies a time period from the beginning of the minute
to the current period.
Period-to-Date Functions
Formulas needing to specify periods may use the period-to-date functions
including those provided in Table 7-7.
