1199
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
53
FIGURE 53-1
Project Properties.Start the New Data Source Wizard by right-clicking the Data Sources folder in the Solutions
Explorer and selecting the New option. After you view the optional welcome screen, the
Select How to Defi ne a Connection screen appears and presents a list of connections. Select
the appropriate connection if it exists.If the appropriate connection does not exist, click the New button and add it. Choose an
appropriate provider, giving preference to native OLE DB providers for best performance.
Then enter the server name, authentication information, database name, and any other
properties required by the chosen provider. Review entries on the All tab and test the con-
nection before clicking OK.Work through the remaining wizard screens, choosing the appropriate login (imperson-
ation) information for the target environment and fi nally the name of the data source. The
choice of impersonation method depends on how access is granted in your environment.
Any method that provides access to the necessary tables is suffi cient for development. You
can modify this later under the Impersonation Information tab of the Data Source Designer,
as shown in Figure 53-2.■ (^) Use a Specifi c Windows Username and Password: Allows the entry of the creden-
tial to be used when connecting to the relational database.
■ (^) Use the Service Account: Uses the account that the Analysis Server service is
logged in under to connect to the relational database.
c53.indd 1199c53.indd 1199 7/31/2012 10:30:22 AM7/31/2012 10:30:22 AM
http://www.it-ebooks.info