Database Reference
In-Depth Information
FIguRe 7-4 Creating a PerformancePoint filter that uses Time Intelligence
Quick Samples
Formula structure: [(]<Period>[Offset>[)][ <Function>[<Offset>]]]
TABle 7-2 Example Formulas
To D I S PL Ay
ForMuLA
r E Su LT
Yesterday
day-1
The previous day relative to the
current date.
Tomorrow
day+1
The next day relative to the cur-
rent date.
The current quar-
ter and today
quarter, day
A set of time periods consisting
of the current day and current
quarter.
Last 10 days
day:day-9
A 10-day range including today.
Last 10 days
(excluding today)
day-1:day-10
A 10-day range NOT including
today.
Same day last year
(year-1).day
Current date (month and day)
for last year. For example, if the
current date were December 10,
2010, then (year-1).day would
show information for December
10, 2009.
Search WWH ::




Custom Search