Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

110



LESSON 12 Configuring a Data SourCe anD Data SourCe View

Step-by-Step

1. Open Business Intelligence Development Studio (BIDS) and navigate to File  New 

Project. Create a new Analysis Services project called Knights24HourSSAS, and save it to

the C:\Projects directory shown in Figure 12-7.

2. In the Solution Explorer, right-click the Data Sources folder and select New Data Source.

FIGURE 127

3. Click Next to bypass the welcome screen and then click New to define a new connection to

the source data.

4. In the Connection Manager dialog (see Figure 12-8), type localhost for the “Server name”

property (this is assuming you have only one instance of SQL Server installed on your machine),

and then select AdventureWorksDW2008R2 from the “Select or enter a database name” prop-

erty. Before you click OK, click Test Connection to make sure you have the permissions to the

database with a Windows account.

5. You will return to the wizard, where you can click Next to continue.

6. Continue with the default “Use a specific Windows user name and password,” and then type

in the name of a Windows account that has permissions to the database. Click Next.

7. Complete the wizard by assigning the data source a name. Type AdventureWorksDW2008R2

for the “Data source name” property and then click Finish.

8. Next, right-click the Data Source Views folder and select New Data Source View. ...