Microsoft® SQL Server® 2012 Bible

1321

Chapter 58: Creating and Deploying BI Semantic Models

58

9. Click Next. The Choose How To Import Data dialog window opens. You can choose
   to select individual tables or write a query that specifi es the data to open. For this
   example, click the Select from a List of Tables and Views to Choose the Data to
   Import option.


10. Click Next. The Select Tables and Views dialog window opens. Select the following
    tables:

■ (^) DimReseller
■ DimProduct
■ (^) DimProductSubcategory
■ DimProductCategory
■ (^) FactResellerSales

11. Click Finish. The import process dialog window opens. In this dialog window, you
    can track the progress of the import process for each table selected. At the end of
    the import process, you can see a summary of each work item, status, row count,
    and messages.


12. Click Close. The data model opens in data view. The tables that were imported in
    the previous step display in separate tabs.
    At this point you have created a basic Tabular project. An important step now is to man-
    age relationships between the tables you imported so you can slice and dice our data with
    dimension attributes.

To manage table relationships click the Table menu option, and select Manage

Relationships. The Manage Relationships window opens. This step is important, because it

ensures you have the right relationships in your model that allow you to slice and dice the

data. The existing relationships listed in the Manage Relationships window are relation-

ships that have been defi ned in the SQL Server database.

To view a graphical representation of our table relationships, click the Model menu option,

click Model View submenu, and select Diagram View. The diagram view of the BI Semantic

model displays. The Diagram View shows the logical relationships between each table in the

data model. Click OK to close the Diagram View.

In addition, you can extend your basic Tabular Project with measures that aggregate data

across a column. For example, you can create a sum of order quantity and a sum of sales

amount by following these steps:

1. Click the Model menu option, click Model View submenu, and select Data View to
   create measures. Click the FactResellerSales tab. Click the column header titled
   OrderQuantity. The entire column is highlighted.


2. Click the Column menu option, click the AutoSum submenu, and select Sum
   from the list. An aggregated column measure named Sum of OrderQuantity is
   created.

c58.indd 1321c58.indd 1321 7/31/2012 10:36:05 AM7/31/2012 10:36:05 AM

http://www.it-ebooks.info