Dimension Designer (Analysis Services - Multidimensional Data)

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

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Dimensions (Analysis Services - Multidimensional Data)

Dimensions in Multidimensional Models