Create a Time Dimension using the SQL Server Data Tools Dimension Wizard

If you database has no Time or Date table you can use the Dimension Wizard in SQL Server Data Tools (SSDT) to generate your Time Dimension.  You can have the tool generate a Time Table either in the data source (if you have permissions) or on the Server.  When creating your Time Table using the Wizard you have the option to specify the Time or Date range the Table will include dates / times between your specified start and end points.

See the article on MS Docs below for more details on creating Time Dimensions automatically using the Dimension Wizard

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/create-a-time-dimension-by-generating-a-time-table?view=sql-server-2017

Leave a Reply

Your email address will not be published. Required fields are marked *