Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Dimension Designer (Analysis Services - Multidimensional Data)


Applies To: SQL Server 2016 Preview

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 this page 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft