Creating Custom Time Tables
The first step in setting up a custom time hierarchy is to define a custom time table, usually in a spreadsheet. This table requires a column containing dates and other columns containing attributes of the dates.
For example:
- A table with a Date column called
Fiscal Date and other attributes such as day/week/month names,
IDs, and sequence numbers.Caution:Include any period shift columns in the table.
- Load the custom time table into Birst using Quick File Upload.
- Enable the source.