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.