Rolling Years  - 365 day periods

Rolling Quarters - 90 day periods

Rolling Months - 30 day periods

Rolling Weeks - 7 day periods



Report creators:

The Rolling Periods attribute displays the ending date of the period. It recalculates with every refresh. As such, it can be used in row or column headers, but not as a filter. It may need the corresponding Key attribute as a sort.


The Rolling Periods Key attribute, like the Relative Date Keys, is an integer where prior periods are negative, today (i.e. last refresh date) is the first day of period zero, and future periods are positive. The Key's are used for relative date filters, and as a sort for how the Rolling Periods attributes display.


TIP: How to sort the Rolling Periods attribute by its corresponding Key.

(RME-04/18/2010 means Rolling Month Ending April 18, 2010.)






DataSelf Back-end Technicians:

The last day of the rolling period with key = -1 should be "yesterday" compared to the Data Refreshed As Of date. However, if the refresh starts before midnight, this may throw this relative date back to day before yesterday (by the next morning when users are using the reports).


In the ETL, the SYSTEM_Date table has a RollingPeriodShift formula that can be changed to shift the rolling periods' ending dates forward or backward.