Share via

Dimension Designer (Analysis Services - Multidimensional Data)

  • Article

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.

      -or-

    • Double-click a dimension.

Pages

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.

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

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

See Also

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