Dimension Designer (Analysis Services - Multidimensional Data)


Applies To: SQL Server 2016

Use Dimension Designer in SQL Server Data Tools (SSDT) to browse the data that the dimension contains, and to modify various properties of an existing dimension: attributes, hierarchies, levels, attribute relationships, and translations.

To display Dimension Designer

  • In SQL Server Data Tools (SSDT), in Solution Explorer, use one of the following procedures procedures:

    • Right-click a dimension and then click Open or View Designer.


    • Double-click a dimension.

Dimension Designer contains the following pages:

Dimension Structure
Use this page to view and modify the attributes, hierarchies, and levels in the dimension.

Attribute Relationships
Use thispage to create, modify or delete the attribute relationships of the selected dimension.

Use this page to view and modify translations associated with the dimension and its attributes, hierarchies, and levels.

Use this page to browse the members of a hierarchy that the dimension contains.

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Dimensions (Analysis Services - Multidimensional Data)
Dimensions in Multidimensional Models

Community Additions