Database Reference
In-Depth Information
Important:
The account you use must have access to both Analysis Server and SQL Server. On a
nonproduction machine, we recommend using an administrator account. in addition, a blank password will
not work here. if you try to use one, you will find later that the cube deployment will fail.
1.
From the Data Source Designer dialog window, select the impersonation information
tab, as shown in Figure
2-56
.
2.
Change the username and password (do not leave the password blank) to an
account that will work on your computer (Figure
2-56
). For example, on Randal's
laptop, he uses RSlaptop2\Administrator for the user account, because this account
has full admin rights on both SQL Server and Analysis Server. You need to change it
to your < computer name > \Administrator.
Figure 2-56.
Setting the impersonation name and password
3.
Click OK to close the Data Source Designer dialog window.
review the project Files
in the next series of steps, simply review the downloaded project files to help familiarize yourself with how
these files are used. in Chapter 9, we discuss what each file does and how to configure the files.
1.
Double-click the
WeatherTrackerDW.dsv
file to open a data source view designer
tab in the center of your screen. This file can be located under the Data Source
views folder in Solution Explorer.
2.
Review the tables displayed in this designer window and note the relationship arrow
that connects the two tables. Double-click the arrow (your cursor will turn into a
double-ended arrow when you hover over it) to cause the Edit Relationship dialog
window to appear.
3.
verify that the EventKey columns are connected via this relationship, and click the
OK button to close the dialog window.
