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 – creating a domain-based relationship


In this example, we will create two other entities for the product and its subcategory. We will then create a relationship between these entities with Excel Add-in.

  1. Create Product Sub Category Entity in the same way we created the product category entity in previous examples. Set Name as English Product Sub Category Name and Code as ProductSubCategoryKey. Use DimProductSubCategory as the source table in AdventureWorksDW2012.

  2. Create a Product entity from DimProduct and set Name as Name column and Code as ProductID.

  3. Open the ProductSubcategory entity in Excel Add-in. Note that there is a column in this entity named ProductCategoryKey. This column does not make sense for a data steward, so we want to change it to point to an equivalent record in the Product Category entity; this will help the data steward to manage data easily.

  4. Select the ProductCategoryKey column and rename it to Product Category.

  5. Select the Product Category column and click...