1304
Part IX: Business Intelligence
- Click Next. The Choose How to Import the Data dialog window opens. You are pre-
sented with two options:
■ (^) Select from a list of tables and views to choose the Data to import.
■ Write a query that will specify the data to import.
For the purposes of this example, select the fi rst option, Select from a list of tables
and views to choose the data to import.
- Click Next. The Select Tables and Views dialog window opens. In this dialog window
you select the tables and views to be included in the BI Semantic Model. You can
choose to import the entire table or add a fi lter to import only a subset of the data. - Select the following tables to import:
■ (^) DimProduct
■ DimProductSubcategory
■ (^) DimProductCategory
■ DimReseller
■ (^) FactResellerSales
Figure 58-5 shows the Select Tables and View dialog window.
FIGURE 58-5
Select Tables and View screen.
c58.indd 1304c58.indd 1304 7/31/2012 10:36:00 AM7/31/2012 10:36:00 AM
http://www.it-ebooks.info