Snapshot Control v1
In the Snapshot_v1 table you define the logic of the active snapshot dates. This all happens by the user input. The active snapshot dates are then selectable in the snapshot-based tables to get the data from these specific dates. As this entity is stored as a view, no updates or incremental loads are necessary. Also only the past snapshot dates will be selected by the view, so it won't come to a conflict with the future dates.
As the configuration contains some kind of repetition, the fields will be explained for one case only, but is considered equal for all cases.
| Config Name | Config Type | Explanation |
|---|---|---|
| Use Logarithmic Logic | Toggle | In the Config section on the right there is a tab called 'Use Logarithmic Logic'. Expand this and you get a toggle 'Use Logarithmic Logic'. The default value is 'TRUE'. Enable this to use your individual logic to active / deactivate snapshot dates. If this is set to 'FALSE', every sdts will be seen as active. |
| As the configuration contains some kind of repetition, the following fields will be explained for one case only, but is considered equal for all cases. | It is the same logic for each of the following: 'Daily', 'Weekly', 'Monthly', 'Quarterly', 'Yearly' | |
| Keep {{...}} Snapshots forever | Toggle | In the Config section on the right there is a tab called '{{...}} Snapshot Logic'. It is only available if 'Use Logarithmic Logic' is set to 'TRUE'. It is also only available, if logically the options are not redundant. As an example, if you set 'Keep Monthly Snapshots forever' to true, the quarterly and yearly snapshots are also been kept forever, as monthly includes quarterly and yearly.
At default set to false, this will determine whether the snapshots flagged as "IS_DAILY" will be kept forever. |
| Duration | textBox | In the Config section on the right there is a tab called '{{...}} Snapshot Logic'. It is only available if 'Use Logarithmic Logic' is set to 'TRUE'. It is also only available, if logically the options are not redundant. As an example, if you set 'Keep Monthly Snapshots forever' to true, this option won't be available from 'Monthly Snapshot Logic' forward, as you keep all the snapshots, and the duration is automatically set to infinite.
A default value is set. At this point you define for how long the snapshots will be kept active. |
| Time Unit | dropdownSelector | In the Config section on the right there is a tab called '{{...}} Snapshot Logic'. It is only available if 'Use Logarithmic Logic' is set to 'TRUE'. It is also only available, if logically the options are not redundant. As an example, if you set 'Keep Monthly Snapshots forever' to true, this option won't be available from 'Monthly Snapshot Logic' forward, as you keep all the snapshots, and the duration is automatically set to infinite.
A default value is set. At this point you define for how long the snapshots will be kept active. At this point you set the time unit for the duration; 'DAY', 'WEEK', 'MONTH', 'QUARTER', 'YEAR' |
| Sys Column Name | Default Value | Explanation |
|---|---|---|
| IS_ACTIVE | The user defined logic will set this to 'TRUE', when one of the requirements is met. Like is it the beginning of a month within the set duration. | |
| IS_LATEST | If the sdts is the latest one in the view, this value will be set tot 'TRUE'. | |
| IS_CURRENT_YEAR | This defines if the sdts is within the current calendar year. | |
| IS_LAST_YEAR | This defines if the sdts is within the last calendar year. | |
| IS_ROLLING_YEAR | This defines if the sdts is within the relative year. So as an example, with the current date of '2022-06-07' the date '2021-08-31' is flagged as 'TRUE', '2021-06-01' will be flagged as 'FALSE'. | |
| IS_LAST_ROLLING_YEAR | This defines if the sdts is within the last relative year. The logic is the same as above, but relates to the last rolling year. |
Create the node:
- In the Browser, select the 'SNAPSHOT_v0_WIKI' and create a new node 'Datavault by Scalefree: Snapshot v1'
- Define the logic whether you want to keep all snapshot dates or use the logarithmic logic
- Create the node