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