1305
Chapter 58: Creating and Deploying BI Semantic Models
58
- 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. - Click Close. The data model opens in data view. The tables that were imported in
the previous step display in separate tabs. - Click the Design menu option, and select Manage Relationships. The Manage
Relationships window opens. This step is important because it ensures you have the
correct relationships in your model to slice and dice the data. The existing relation-
ships listed in the Manage Relationships window are relationships that have been
defi ned in the SQL Server database. Click Close to close the Manage Relationships
window. - Click the Home tab, and select Diagram View from the View section. The diagram
view of the BI Semantic Model displays. The Diagram View shows the logical rela-
tionships between each table in the data model, as shown in Figure 58-6.
FIGURE 58-6
Diagram view.At this point you are ready to see the results of your PowerPivot analysis. To interact with
the in-memory BI Semantic Model follow these steps:- Under the Home tab, click the PivotTable icon. A pop-up window opens prompting
you to specify where you want to create the PivotTable.
c58.indd 1305c58.indd 1305 7/31/2012 10:36:00 AM7/31/2012 10:36:00 AM
http://www.it-ebooks.info