Select Build Method (Dimension Wizard)
Use the Select Build Method page to choose how to build the dimension.
Options
- Build the dimension using a data source
Select this option to create a dimension with a data source. Selecting this option makes the Auto build option available.
Auto build
Select to use the auto build technology. The auto build technology makes recommendations during the design process based on the database structure and user input. Clear this option to create a dimension manually, without suggestions from the auto build technology.The following table describes the auto build values and their purpose. These values determine the form of the suggested hierarchies.
Value Description Create attributes and hierarchies
Select to have the wizard create an attribute for most columns in the dimension tables and try to build hierarchies that have multiple levels.
Create attributes
Select to have the wizard create an attribute for most columns in the dimension tables.
- Build the dimension without using a data source
Select to create the dimension without an existing data source view. Attributes will be created manually, without suggestions from the auto build technology. Selecting this option will make the Use a dimension template option available.
- Use a dimension template
Select to create a dimension based on an existing template. Templates provide a complete set of attribute and hierarchy definitions oriented towards a specific business purpose.
See Also
Reference
Dimension Wizard F1 Help (SSAS)
Other Resources
Dimensions (Analysis Services)
Defining and Configuring Dimensions, Attributes, and Hierarchies