Time for action – using the Dimension Designer

The Dimension Usage tab is a specific designer for dimensions in the SSDT. In the next example, you will see how to create new attributes using the Dimension Designer:

  1. In the Solution Explorer, right under dimensions, double-click on Sales Territory.
  2. A new designer window will be opened; this designer is called a Dimension Designer.
  3. In the Dimension Structure tab, drag-and-drop Sales Territory Region from the Data Source View pane to the Attributes pane.
  4. Do this for Sales Territory Group and Sales Territory Country as well.
  5. Select Sales Territory Key in the Attributes pane, and then in the Properties window, change the AttributeHierarchyVisible property of this attribute to false.
  6. Save the changes and process ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial