Calendar or Date Dimension - OptimalBI/optimal-data-engine-mssql GitHub Wiki

Almost everything a data warehouse is asked to do involves dates: days, weeks, months, years, periods of interest, special days. These date details “are attached to virtually every fact table to allow [easy] navigation…” (Source: Kimball Group)

A date dimension consolidates these details in one place in your data warehouse, delivering these benefits:

• Every part of your warehouse understands dates and their attributes in the same way
• Common understanding reduces the burden on bespoke ETL code to calculate dates to satisfy reporting requirements
• Ability to traverse to any other grouping of dates, e.g. from months to quarters, or quarters to years

You can download ODE Calendar reference ensembles from here. Follow the instruction to install Calendar to your ODE Data Vault and populate with the data. Code also includes New Zealand public holidays.