Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 the dimension. You can process the dimension with the Process button, which is the second button from the top left-hand side of the dimension structure tab.

  7. Go to the Browser tab in the Dimension Designer and then reconnect to a process (you can...