Defining interpolation calendars

To specify an interpolation calendar definition:

  1. Select Configuration > Common > Interpolation Calendars.
  2. Click New.
  3. Specify this information:
    Name
    Specify the name of the interpolation calendar.
    Display Name
    Specify the name to be displayed in the application. This is an optional field.
    Description
    Specify the description for the interpolation calendar.
  4. In the Default Pattern pane, specify the default pattern for the selected day of the week. This must be a decimal value >=0.
  5. On the Details tab, click New.
  6. In the Override Pattern pane, specify this information:
    Note: The override patterns consist of a list of interpolation values used to override the default pattern defined for the specified date range . Defining these patterns is optional.
    Date After
    Select the date from which the override pattern must be applicable. Override pattern is applicable for the days after this date. If the override pattern is required to be applied for a range of dates, you must also specify the Date Before.
    Date Before
    Select the date until which the override pattern must be applicable. Override pattern is applicable for the days before this date. If the override pattern must be applied for a range of dates, you must also specify the Date After.
    Description
    Specify the description for the override pattern.
    Sunday
    Specify the override pattern for the selected day of the week (Sunday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Monday
    Specify the override pattern for the selected day of the week (Monday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Tuesday
    Specify the override pattern for the selected day of the week (Tuesday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Wednesday
    Specify the override pattern for the selected day of the week (Wednesday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Thursday
    Specify the override pattern for the selected day of the week (Thursday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Friday
    Specify the override pattern for the selected day of the week (Friday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.
    Saturday
    Specify the override pattern for the selected day of the week (Saturday) that can be used to override the default pattern for the specified date.
    Note: This must be a decimal value>=0.

    When you import the interpolation calendar configuration using a template, the application ensures that the specified dates are valid, and in the required (yyyy-mm-dd) format.

  7. To save the calendar, click Submit.

Applying override patterns

You can apply the override patterns for a specific date range using the Date After, Date Before, (Date After and Date Before) fields. This allows you to specify date ranges with an overlap.

General rules:

  • Any range that exists completely within other ranges is considered.
  • If two ranges overlap and provide conflicting patterns (for example, range A start < B start, but A end > B start) the last range added (B) is applied for the intersected dates. The other range can be applied outside of this intersecting area, if not conflicting with any other ranges.
  • The default pattern for which date range is not specified, (Date Before or Date After) can be applied where no override pattern exists on the specified date.

The first entry (row) is the default pattern for which date range is not specified.

Date After Date Before Monday Tuesday Wednesday Thursday Friday Saturday Sunday
1 1 1 1 1 0 0
2014-01-01 1 1 1 1 1 1 0

An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. All the periods before 2014-01-01 use the default pattern.

The first entry (row) is the default pattern for which date range is not specified.

Date After Date Before Monday Tuesday Wednesday Thursday Friday Saturday Sunday
1 1 1 1 1 0 0
2014-01-01 1 1 1 1 1 1 0
2014-03-01 2014-04-01 1 1 1 0 0 0 0
  • An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. Only the periods between 2014-03-01 and 2014-04-01 use the specified override pattern (1,1,1,0,0,0,0).
  • All the periods after 2014-04-01 use the specified override pattern (1,1,1,1,1,1,0).
  • All the periods before 2014-01-01 use the default pattern.

The first entry (row) is the default pattern for which date range is not specified.

Date After Date Before Monday Tuesday Wednesday Thursday Friday Saturday Sunday
1 1 1 1 1 0 0
2014-01-01 1 1 1 1 1 1 0
2014-04-01 1 1 1 1 2 0 0
  • An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. This override pattern is only used until 2014-04-01.
  • All the future periods from 2014-04-01 use the specified override pattern (1,1,1,1,2,0,0).
  • All the periods before 2014-01-01 use the default pattern.