Select Creation Method (Dimension Wizard)
Use the Select Creation Method page to select how to create the dimension.
To open the Dimension Wizard
- In SQL Server Data Tools (SSDT), in Solution Explorer, right-click the Dimensions folder for an Analysis Services project, and then click New Dimension.
Options
Use an existing table
Create a dimension from one or more tables in a data source. The attributes that are available for the dimension will depend on the structure of the data in the table.For more information, see Create a Dimension by Using an Existing Table.
Generate a time table in the data source
Create a time table in the underlying data source and then use that table to create a time dimension. Use this option when no such table exists and you do not want to use a script to create one. The new time table will contain data for the date range, attributes, and calendars that you specify in the wizard.Note
To use this option, you must have permission to create objects in the underlying data source. If you do not have permission to create objects on the data source, try to use the Generate a time table on the server option instead.
For more information, see Create a Time Dimension by Generating a Time Table.
Generate a time table on the server
Create a time table directly on the server and then use that table to create a time dimension. Use this option if you do not have permission to create objects in the underlying data source. The new time dimension will contain data for the date range, attributes, and calendars that you specify in the wizard.For more information, see Create a Time Dimension by Generating a Time Table.
Generate a non-time table in the data source
Design the dimension without an underlying relational data source, and then generate the necessary schema for the data source. This approach is known as top-down modeling.Note
To use this option, you must have permission to create objects in the underlying data source.
You can build the dimension with or without a template. To build the dimension with a template, select the template from the Template list.
For more information, see Create a Dimension by Generating a Non-Time Table in the Data Source.
Template
Select the template that you want to use to create the dimension. Templates provide a complete set of attribute and hierarchy definitions oriented towards a specific business purpose.Note
This option is only available when the Generate a non-time table in the data source option has been selected.