Calling Views and Stored Procedures from Excel - Microsoft Business Intelligence Tools for Excel Analysts - page 220

Creating a Data Model with
Multiple SQL Data Objects
In Chapter 2, you discovered the internal Data Model, which allows you to analyze multiple data
tables in a single PivotTable. That functionality extends to external datasets. This gives you the power
to use a normalized set of tables from an external database in an analysis cube. If you're unfamiliar
with the internal Data Model, turn to Chapter 2, which gives you the foundation you need.
To understand the benefit of using external data in a Data Model, follow these steps:
1. On the Data tab, select From SQL Server from the From Other Sources drop-down list.
The Data Connection Wizard opens, as shown in Figure 11-10.
Figure 11-10: Enter your authentication information.
2. Configure your connection settings (server name, username, and password) so Excel can
establish a link to the server. Click Next.
The Select Database and Table screen of the wizard appears, as shown in Figure 11-11.
3. Select the database with which you are working, and then select the Enable Selection of
Multiple Tables check box.
4. Select all the tables and views you want imported into the workbook Data Model and then
click Next.
The Import Data dialog box, shown in Figure 11-12, opens.