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.
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 asProductSubCategoryKey
. UseDimProductSubCategory
as the source table in AdventureWorksDW2012.Create a Product entity from DimProduct and set Name as
Name column
and Code asProductID
.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.Select the
ProductCategoryKey
column and rename it toProduct Category
.