Dates.MyDate
Purpose Calendar Year Sample Exec Response SQL
Global
Organisation-wide reference data used across all domains.
Dates.Dim_Date
Purpose Combined Date Table (myDate & Period) filtered for single company Sample Exec Parameters [Date_Key] Response Holiday Period SQL
Steps to create Global Dimension
In myBMT Table object Check table has Data Fields objects Mark Data Fields for Controller Snippet Create Data Mart controller Export Data Mart Controller snippet In VS-Code or SSMS Execute Upsert Check Data