Dimension Wizard F1 Help

Use the Dimension Wizard in SQL Server Data Tools (SSDT) to create a database dimension in a Microsoft SQL Server Analysis Services project. After you create a database dimension, you can use Dimension Designer to modify its properties. For more information about Dimension Designer, see Dimension Designer (Analysis Services - Multidimensional Data).

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.

In This Section

• Select Creation Method (Dimension Wizard)

• Define Time Periods (Data Source) (Dimension Wizard)

• Define Time Periods (Dimension Wizard)

• Select Calendars (Dimension Wizard)

• Specify Source Information (Dimension Wizard)

• Select Related Tables (Dimension Wizard)

• Select Dimension Attributes (Dimension Wizard)

• Specify Dimension Type (Dimension Wizard)

• Specify Dimension Key and Type (Dimension Wizard)

• Define Account Intelligence (Dimension Wizard)

• Completing the Wizard (Dimension Wizard)

See Also

Reference

Analysis Services Wizards (Multidimensional Data)

Concepts

Dimensions (Analysis Services - Multidimensional Data)

Dimensions in Multidimensional Models