You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time dimension. What should

The Dimension Wizard in SQL Server Data Tools includes an option to generate a time table directly in the underlying data source when no such table exists. This creates both the physical table in the relational database and the corresponding SSAS time dimension, satisfying the requirement without needing a pre-existing time table.

The 'Define dimension intelligence' option in the Business Intelligence Wizard maps existing dimension attributes to standard roles; it does not create a new time dimension or generate a source table.

The 'Define time intelligence' option in the Business Intelligence Wizard adds MDX-based time calculation support to an already existing time dimension; it cannot create a new time dimension from scratch.

Adding a dimension from an existing SSAS database requires that another SSAS database with a time dimension already exists, which is not guaranteed by the scenario.