After you create an Analysis
Services project, you generally start working with the project by defining
one or more data sources that the project will use. When you define a data
source, you are defining the connection string information that will be used to
connect to the data source.
To define a new data source:
1.
Solution Explorer (on the right of the
Microsoft Visual Studio window), right-click Data Sources, and then
click New Data Source.
2.
On
the Welcome to the Data Source Wizard page of the Data
Source Wizard, click Next to open the Select how to
define the connection page.
3.
On
the Select how to define the connection page, you can define a
data source based on a new connection, based on an existing connection, or
based on a previously defined data source object. In this tutorial, you define
a data source based on a new connection. Verify that Create a data
source based on an existing or new connectionis selected, and then
click New.
4.
In
the Connection Manager dialog box, you define connection
properties for the data source. In the Provider list box,
verify that Native OLE DB\SQL Server Native Client 11.0 is
selected.Analysis Services also supports other providers, which are displayed
in the Providerlist.
5.
In
the Server name text box, type localhost.To
connect to a named instance on your local computer, type localhost\<instance
name>. To connect to the specific computer instead of the local computer,
type the computer name or IP address.
6.
Verify
that Use Windows Authentication is selected. In the Select
or enter a database name list, select AdventureWorksDW2012.
7.
Click Test
Connection to test the connection to the database.
8.
Click OK,
and then click Next.
9.
On
the Impersonation Information page of the wizard, you define
the security credentials for Analysis Services to use to connect to the data
source. Impersonation affects the Windows account used to connect to the data
source when Windows Authentication is selected. Analysis Services does not
support impersonation for processing OLAP objects. Select Use the
service account, and then click Next.
10.
On
the Completing the Wizard page, accept the default name, Adventure
Works DW 2012, and then click Finish to create the new
data source.
BACK TO SSAS TUTORIAL
BACK TO SSAS TUTORIAL
No comments:
Post a Comment