Operators in relative time period conditions
Table 11‑4 describes the time periods available for the Time Period property. All the time periods are relative to a reference date, which can be the current date defined as the date the report runs, a date you specify, or the latest date in the time dimension.
Table 11‑4 Supported time periods
Time period
Description
Current Month
The entire month relative to the month and year portions of the reference date. For example, if the reference date is 2011‑01‑10, the period is 2011‑01‑01 to 2011‑01‑31.
Current Period
The entire period from a specified period relative to the reference date. For example, use to aggregate data for the same quarter five years ago.
This time period requires two additional properties:
*The First Period, which specifies year, quarter, or month as the type of period for which to aggregate data
*Number of Periods Ago, which specifies the number of prior periods (type of period specified next), from which to begin the calculation
*The Second Period, which specifies year, quarter, month, or day as the type of period
For example, if the reference date is 2012-02-08, to aggregate data for the same quarter five years ago, specify the following:
*The First Period: Quarter
*Number of Periods Ago: 5
*The Second Period: Year
Data is aggregated for the entire quarter, 2007‑01‑31 to 2007‑03‑31.
Current Quarter
The entire quarter relative to the month and year portions of the reference date. For example, if the reference date is 2011‑12‑15, the period is 2011‑10‑01 to 2011‑12‑31.
Current Year
The entire year relative to the year portion of the reference date. For example, if the reference date is 2011‑06‑30, the period is 2011‑01‑01 to 2011‑12‑31.
Month to Date (MTD)
The period starting at the beginning of the reference date’s month and ending at the reference date. For example, if the reference date is 2011‑12‑25, the period is 2011‑12‑01 to 2011‑12‑25.
Month to Date Last Year
Same as Month to Date, but for the previous nth year. This time period requires another property, Number of Years Ago, which specifies which prior year. For example, if the reference date is 2011‑12‑25 and Number of Years Ago is 1, the period is 2010‑12‑01 to 2010‑12‑25.
Next N Periods
The next n periods from the reference date. This time period requires two additional properties:
*Number of Periods Ago, which specifies the number of periods
*The First Period, which specifies year, quarter, month, week, or day as the period in which to begin the calculation
For example, if the reference date is 2012‑01‑01, Number of Periods Ago is 1, and The First Period is Month, then the period is 2012‑01‑01 to 2012‑01‑31.
Period To Date
The period from a specified period relative to the reference date. For example, use to aggregate data for the same quarter to date, five years ago.
This time period requires three additional properties:
*The First Period, which specifies either year, quarter, or month as the type of period for which to aggregate data
*Number of Periods Ago, which specifies the number of prior periods (type of period specified next), from which to begin the calculation
*The Second Period, which specifies either year, quarter, month, or day
For example, if the reference date is 2012‑02‑08, to aggregate data for the same quarter up to 02‑08, five years ago, specify the following:
*The First Period: Quarter
*Number of Periods Ago: 5
*The Second Period: Year
Data is aggregated for 2007‑01‑01 to 2007‑02‑08.
Previous N Month
The previous nth month relative to the month and year portion of the reference date. The day portion is ignored. This time period requires another property, Number of Months Ago, which specifies which prior month. For example, to specify three months back from the reference month, type 3. If the reference date is 2012-01-15 and N Months Ago is 3, then the period is 2011-10-01 to 2011‑10‑31.
Previous N Month to Date
The previous nth month relative to the reference date. This time period requires another property, Number of Months Ago, which specifies which prior month. For example, to specify three months back from the reference date, type 3. If the reference date is 2012‑01‑15 and Number of Months Ago is 3, then the period is 2011‑10‑01 to 2011‑10‑15.
Previous N Quarter
The previous nth quarter relative to the month and year portion of the reference date. The day portion is ignored. This time period requires another property, Number of Quarters Ago, which specifies which prior quarter. For example, to specify one quarter back from the reference date, type 1. If the reference date is 2012‑03‑15 and Number of Quarters Ago is 1, then the period is 2011‑10‑01 to 2011‑12‑31.
Previous N Quarter to Date
The previous nth quarter relative to the reference date. This time period requires another property, Number of Quarters Ago, which specifies which prior quarter. For example, to specify one quarter back from the reference date, type 1. If the reference date is 2012‑03‑15 and Number of Quarters Ago is 1, then the period is 2011‑10‑01 to 2011‑12‑15.
Previous N Year
The previous nth year relative to the year portion of the reference date. This time period requires another property, Number of Years Ago, which specifies which prior year. For example, to specify two years back from the reference date, type 2. If the reference date is 2011‑09‑30 and Number of Years Ago is 2, then the period is 2009‑01‑01 to 2009‑12‑31.
Previous N Year to Date
The previous nth year relative to the reference date. This time period requires another property, Number of Years Ago, which specifies which prior year. For example, to specify two years back from the reference date, type 2. If the reference date is 2011‑09‑30 and Number of Years Ago is 2, then the period is 2009‑01‑01 to 2009‑09‑30.
Quarter to Date (QTD)
The period starting at the beginning of the reference date’s quarter and ending at the reference date. For example, if the reference date is 2011-12-25, the period is 2011‑10‑01 to 2011‑12‑25.
Quarter to Date Last Year
Same as Quarter to Date, but for the previous nth year. This time period requires another property, Number of Years Ago, which specifies which prior year. For example, if the reference date is 2011‑12‑25 and Number of Years Ago is 1, then the period is 2010‑10‑01 to 2010‑12‑25.
Trailing N Days
The last n days from the reference date. This time period requires another property, Number of Day(s) Ago, which specifies the number of trailing days. For example, if the reference date is 2011‑12‑25, and Number of Day(s) Ago is 15, then the period is 2011‑12‑10 to 2011‑12‑24.
Trailing N Months
The last n months from the reference date. This time period requires another property, Number of Months Ago, which specifies the number of trailing months. For example, if the reference date is 2011‑12‑25, and Number of Months Ago is 3, then the period is 2011‑09‑25 to 2011‑12‑25.
Trailing N Periods
The last n periods from a specified period relative to the reference date. For example, use to aggregate data for the two months prior to the reference date five years ago.
This time period requires four additional properties. The first and second properties define the period for which to aggregate data:
*Number of Periods Ago, which specifies the number of periods
*The First Period, which specifies year, quarter, month, or day as the type of period
The third and fourth properties define the period relative to the reference date from which to begin the calculation.
*Number of Periods Ago, which specifies the number of prior periods
*The Second Period, which specifies either year, quarter, month, or day as the type of period
For example, if the reference date is 2012-01-01, to aggregate data for the two months prior to January 1 five years ago, specify the following:
*Number of Periods Ago: 2
*The First Period: Month
*Number of Periods Ago: 5
*The Second Period: Year
Data is aggregated for the period 2007-11-01 to 2007-12-31.
Year to Date (YTD)
The period starting at the beginning of the reference date’s year and ending at the reference date. For example, if the reference date is 2011‑06‑30, the period is 2011‑01‑01 to 2011‑06‑30.