Buckets
Buckets are used to group time into smaller periods. The buckets are used for reporting, and also in the forecasting and inventory planning calculations.
You can populate these in three different ways:
Use our standard time buckets. They can be loaded using the “load a dataset” feature in the execution screen - select “dates” from the list.
Use the “generate buckets” command from the “execution screen”.
You can of course upload your own time buckets from a CSV or Excel file.
Fields
Field |
Type |
Description |
|---|---|---|
name |
string |
Unique name. |
description |
string |
Free text description. |
level |
integer |
Hierarchical indication. Higher numbers are used for detailed buckets, eg days. Lower numbers are used for coarse buckets, eg years. |
Bucket detail
The bucket detail table define how the time horizon is divided in buckets.
When populating this table make sure to respect the following simple guidelines:
For a given horizon name all dates need to belong to a single time bucket. It not okay to leave gaps between time buckets or have overlapping time bucket.
For a given horizon name the start date of a time bucket must be equal to the end date of the time bucket preceding it.
Make sure to cover a period that is long enough: eg from 2014 till 2019.
Fields
Field |
Type |
Description |
|---|---|---|
bucket |
string |
References the bucket table. |
name |
name |
Label for this time bucket in the user interface. |
start date |
dateTime |
Starting date of the time bucket. |
end date |
dateTime |
Ending date of the time bucket. |