Effective dates in UCE
Formula channels have two properties that define the time range of intervals over which that formula is effective: the effective start date and the effective stop date. This enables you to swap out interval channels at defined time periods without editing the formula channel. If gaps exist in the effective date ranges of the formula definitions, UCE fails to return any results for a request that covers the date range of the gap.
For example, assume a formula channel with the following formula definitions:
|
Effective start |
Effective stop |
Formula |
|---|---|---|
|
January 1 |
February 3 |
SP1:1 + SP2:1 |
|
February 4 |
March 19 |
SP1:1 + SP3:2 |
|
March 20 |
<none> |
SP2:1 + SP5:9 |
The formula calculates intervals that fall between January 1 and February 3 as SP1:1 + SP2:1.
It calculates intervals that fall between February 4 and March 19 as SP1:1 + SP3:2.
And it calculates intervals that fall after March 19 as SP2:1 + SP5:9.
Whenever UCE calculates a Stored and nonstored formula channels formula channel, it takes these effective dates into account.
Related topics: