Database Reference
In-Depth Information
11. Select the first option from a list of tables and views to choose the data to
import and then click on the
Next
button to continue.
12. The next page, titled
Select Tables and Views
, allows you to select multiple
objects to import. For each, you can include or omit different columns, re-
name the imported table, and filter unwanted records.
13. Click on the checkboxes to place a check mark in front of the
DimPro-
ductCategory
and
DimProductSubcategory
tables.
Note
The next step may not seem perfectly intuitive until I explain the purpose.
Oftentimes in the semantic model, we need to import objects used for in-
ternal purposes. We also need to give visible objects the best names and
hide those that will only be used internally. You will rename two impor-
ted tables with the first table used only for internal purposes. After you're
done with the final design, the new
Product Category
table will con-
tain both product category and subcategory information.
14. In the
Friendly Name
column for the
DimProductCategory
table, rename
the table to
_ProductCategory
.
15. Rename the
DimProductSubcategory
table to
Product Category
.
Search WWH ::
Custom Search