Clarity: Time Slice Definition Expiration Date

Document ID : KB000050490
Last Modified Date : 14/02/2018
Show Technical Document Details


When modifying a timeslice in time slice requests table, there is a field to set the expiration date (to determine on what day the rollovers should happen. On certain slices it ignores this field and sets the expiration date to another number. For example, trying to set Resource Monthly Availability to roll over on the 10th of the month, I enter 7/10/2011 as the expiration date. It ignores this and sets it to 7/1/2011.

SQL tracing shows that the app is telling the DB to set it to 7/1/2011 even though I typed something different in the UI.


The Time Slice Definition Expiration Date is automatically calculated by the application based on the Rollover Interval and the From Date.

The Expiration Date is initially set when the Time Slice Definition is created or updated, but when the Time Slicing job executes, the Expiration Date is checked and recalculated based on the configuration described below.

Figure 1

Figure 1: Example Monthly Rollover Time Slice Definitions

Based on the screenshots above, the Expiration Dates for the Time Slice Definitions with 'Monthly' Rollover Intervals will be calculated for the upcoming Month. For 'Daily' Slice Periods, the day of the Month is based on the day in the 'From Date' value. So you can see in some 'Daily' Slice Period definitions, the Expiration Date is set to the 1st and others are set to the 15th of the Month based on the 'From Date'. Best Practices for Time Slice Definitions 1, 2, 3, 10, and 11 recommend that these daily slice definitions always start on the 1st of the month. In configuring 'Monthly' Slice Periods, it is recommended to always set the From Date on the 1st of the month. The 'Monthly' Rollover Interval for a 'Monthly' Slice Period will set the Expiration Date for the upcoming Month and will always set it to the 1st of the month.

Figure 2

Figure 2: Example Weekly & Quarterly Rollover Time Slice Definitions

For 'Weekly' Slice Periods, the Expiration Date is based on the Rollover Interval set as 'Weekly' and is calculated for the upcoming week and will be set for the upcoming Monday. The 'From Date' is not part of this calculation.

For 'Quarterly' Slice Periods with a 'Quarterly' Rollover Interval, the Expiration Date is set to the beginning of the next Quarterly interval based on the From Date.

Figure 2

Reference TEC435572 - How should I configure my Time Slices in Clarity?

Keywords: CLARITYKB, how-to, best practices.