使用Time Intelligence Formula

Time Intelligence允许你在Dashboard上指定一个公式当作过滤器。这个公式就是Time Intelligence Post Formula用来定义一个关于时间的过滤器，它允许你使用单独的一个Time Intelligence Formula去计算不同的时间范围，比如说，过去N年，过去2个季度，未来4个季度，过去12个月等等都在相同的仪表板上。这个过滤器提供一个在公式中使用的参考日期。默认情况下，这个参考日期是当前日期，但是你可以通过常见的日历选择器控制来把它设置为任何日期。

Time Intelligence Formula的格式：

   

Formula Structure

 [(]<Period>[<Offset>[)][.<Function>[<Offset>]]]

   

Examples of Time Intelligence expressions

The following table shows some Time Intelligence expressions along with some examples.

To Get…	Formula	Result
Yesterday	day-1	The previous day relative to the current date.
Tomorrow	day+1	The next day relative to the current date.
The current quarter 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 (not including today)	day-1:day-10	A 10 day range NOT including today.
Same day last year	(year-1).day	Parallel period: days by year.
Same quarter last year	(year-1).month	Parallel period: Quarter by year.
Same range of months last year	(year-1).(month-5): (year-1).(month)	Set of parallel periods last year to the last six months.
Same range of months to date for last year	(year-1).firstmonth: (year-1).month	From the first month of last year to the month parallel to the current month this year.
Year to date	yeartodate	A single time period representing the aggregation of values from the beginning of the year to the last completed period.  The period corresponds to the most granular time period defined for the data source.
Year to date (by month)	yeartodate.fullmonth	A single time period representing the aggregation of values from the beginning of the year to the last completed month.
Year to date (by day)	yeartodate.fullday	A single time period representing the aggregation of values from the beginning of the year to the last completed day.
Parallel year to date	yearToDate-1	The aggregation of the same set of default time periods completed in the current year except for the prior year.
Parallel year to date (by month)	(yearToDate-1).fullMonth	The aggregation of the same set of months completed in the current year except for the prior year.

   

常用的操作符

   

操作符	用法
"."	点操作符，获取父对象的成员。 例如:  year.firstMonth
"+" or "-"	使用加减号来进行基于当前日期偏移量的算术运算。 例如：:  day-1 / day+1
"()"	将对于某个日期的偏移量作为整体，相当于函数。 例如:  (year-1).firstMonth:(year-1).month
","	分隔符 例如:   year, Quarter, Month, day
":"	分号用来确定一个时间段. 例如： day:day-4

   

标准的时间段：

在Performance Point Service/Server中包含以下标准的时间段属性成员：

   

Period	Example
Year	Year-1, year+2
Quarter	quarter, Quarter-4
Month	Month-2
Week	Week-51
Day	Day-9, day+2
Hour	Hour-12
Minute	minute-30
Second	second+5

   

标准时间段成员：

如下函数均可以在标准时间段之后以点的形式做为成员输出相应的值，类似于函数:

MemberFunction	Description	Examples
Parent	The parent level of time aggregation from the data source	Day.Parent
FirstChild	The first child aggregation level from the data source	Month.FirstChild
LastChild	The last child aggregation level from the data source	Month.LastChild
FirstSemester	Returns the first semester of the parent time period. The parent member for this function must be Year.	Year.FirstSemester
LastSemester	Returns the last semester of the parent time period. The parent member for this function must be Year.	Year.LastSemester
FirstQuarter	Returns the first quarter of the parent time period. The parent member for this function must be one of semester or year.	Year.FirstQuarter Semester.FirstQuarter
LastQuarter	Returns the last quarter of the parent time period. The parent member for this function must be one of semester or year.	Year.LastQuarter (Semester-1).LastQuarter
FirstMonth	Returns the first month of the parent period.	Year.FirstMonth (Year-1).FirstMonth
LastMonth	Returns the last month of the parent period.	Year.LastMonth (Quarter+1).LastMonth
FirstWeek	Returns the first full week of the parent period.	Year.FirstWeek (Semester-1).FirstWeek
LastWeek	Returns the last full week of the parent period.	Year.LastWeek (Semester+1).LastWeek
FirstDay	Returns the first day of the parent period.	Month.FirstDay (Month-1).FirstDay
LastDay	Returns the last day of the parent period.	Month.LastDay (Month+1).LastDay
FirstHour	Returns the first hour of the parent period.	Day.FirstHour (Day-1).FirstHour
LastHour	Returns the last hour of the parent period.	Day.LastHour (Day+1).LastHour
FirstMinute	Returns the first minute of the parent period.	Day.FirstMinute (Hour-2).FirstMinute
LastMinute	Returns the last minute of the parent period.	Day.LastMinute (Hour+2).LastMinute
FirstSecond	Returns the first second of the parent period.	Hour.FirstSecond (Minute-10).FirstSecond
LastSecond	Returns the last second of the parent period.	Hour.LastSecond (Minute+9).LastSecond

   

Periods-To-Date

   

在Performance Point Service 2010中还新增了Periods-To-Date类型，其实是描述了一个时间区间。

Period	Use	Works with…
YearToDate	Specifies a time period from the beginning of the year to the current period.	FullQuarter functions or lower.
QuarterToDate	Specifies a time period from the beginning of the quarter to the current period.	FullMonth functions or lower.
MonthToDate	Specifies a time period from the beginning of the month to the current period.	FullWeek functions or lower.
WeekToDate	Specifies a time period from the beginning of the week to the current period.	FullDay functions or lower.
DayToDate	Specifies a time period from the beginning of the day to the current period.	FullHour functions or lower.
HourToDate	Specifies a time period from the beginning of the hour to the current period.	FullMinute functions or lower.
MinuteToDate	Specifies a time period from the beginning of the minute to the current period.	FullSecond function.

   

与之可以使用的函数：

Function	Use	Works with…
FullQuarter	Specifies that the period to date should include up to the last full quarter.	YearToDate
FullMonth	Specifies that the period to date should include up to the last full month.	QuarterToDate periods of higher.
FullWeek	Specifies that the period to date should include up to the last full week.	MonthToDate periods of higher.
FullDay	Specifies that the period to date should include up to the last full day.	WeekToDate periods of higher.
FullHour	Specifies that the period to date should include up to the last full hour.	DayToDate periods of higher.
FullMinute	Specifies that the period to date should include up to the last full minute.	HourToDate periods of higher.
FullSecond	Specifies that the period to date should include up to the last full second.	MinuteToDate periods of higher.  Note this is included for consistency, though technically this period is not needed.