(2) define a data source

After you create a Microsoft SQL Server 2005 Analysis Services (SSAs) project, you can use the project by defining one or more data sources that the project will use. When defining a data source, it defines the connection string information to be used to connect to the data source. For more information, see .

In the following tasksAdventureworksdwThe sample database is defined as the data source of the Analysis Services Tutorial Project. For the purpose of this tutorial, the database is located on your local computer, and the source database usually resides on one or more remote computers.

Define a new data source

2. In Solution Explorer, right-click"Data Source"And then click"Create a data source".

   The data source wizard opens.

4. In"Welcome to the data source wizard"Page, click"Next".

   Will display"Select how to define a connection"Page. On this page, you can define data sources based on new connections, existing connections, or data source objects previously defined. The previously defined data source object is an existing data source definition in the current project or other projects of the current solution. In this tutorial, the new data source is defined based on the new connection.

6. In"Select how to define a connection"Page, make sure that you have selected"Create a data source based on an existing connection or a new connection"And then click"New".

   Will display"Connection Manager"Dialog box. In this dialog box, you can define the Connection Properties of the data source. The Connection Manager is the logical representation of the connection that will be used during running. For example, the Connection Manager includes a connection string attribute set during design. during runtime, a physical connection is created by using the value in the connection string attribute.

8. In the "provide Programs " list, make sure that "Local ole db \ SQL native client" is selected.

   Analysis Services also supports other access interfaces displayed in the "providers" list.

10. In"Server name"In the text box, typeLocalhost.

    To connect to the named instance on the Local Computer, TypeLocalhost \ <Instance name>. When a project is deployed to a special instance of analysis services, the Analysis Services engine connects to the specified database of the default instance of Microsoft SQL Server (located on the computer where the Analysis Services instance is located. If you specify a specific computer name or IP address when defining a data source, the project or deployed application establishes a connection with the specified computer rather than the local computer. The analysis services deployment wizard allows you to specify the actual server name of the source data during deployment. For more information, see .

12. Make sure you have selected"Use Windows Authentication". In"Select or enter a database name"List, selectAdventureworksdw.

    Displays the settings that have been defined so far."Connection Manager".

14. Click"OK"And then click"Next".

    Will display"Simulation information"Page. On this page of the wizard, you can define the security creden。 used by analysis services to connect to the data source. The simulation affects the Windows account used to connect to the data source when "Windows Authentication" is selected. Analysis Services does not support using the simulation function to process OLAP objects.

16. Select"Use Service Account"And then click"Next".

    Displays"Complete wizard"Page.

18. In"Complete wizard"Page, click"Done"To create a project namedAdventure works DW.

    Shows the solution resource manager's"Data Source"Folder.

To modify the attributes of an existing data source, go"Data Source"Double-click the data source in the folder"Data Source designer"Data Source properties are displayed.

 

You have successfully defined the adventure works DW data source for the Analysis Services Tutorial Project.

Next task in the course