Adding a Microsoft Analysis Services connection

To add a generic Microsoft Analysis Services connection:

  1. On the Manage Data Sources page.
  2. Click New and select Microsoft Analysis Services as the connection type.
  3. Specify a name for the data source. The name must be unique.
  4. Select Model as the category.
  5. To define the Analysis Services Connection:
    1. Specify the name of the server computer.
    2. Specify the user name of the database owner.
    3. Specify the password for the administrator user.
    4. Select the database to connect to the data source. If necessary, click Refresh to update the list of available databases.
  6. Click Test Connection.
  7. Click Save.