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.

   

   

   

    

   

   

   

   

 

posted on 2010-08-13 23:55  Allan.  阅读(692)  评论(0编辑  收藏  举报