When you choose Analysis Services as the data source, you need to create a connection to an Analysis Server cube by configuring the following settings.

Server

Enter the name of the Analysis Services database server and click Connect to connect to the server.

Database

Choose a database to access from the dropdown list.

Connection String

Click on the Connection String tab to display the connection string to the database.

In most cases the generated connection string requires no editing. However, if you wish to make any changes or add an option, click Edit  to open the Connection String Editor.

Edit the string and click Test Connection to test the connection. The system indicates whether or not the connection is working.

Click OK.