How to add or change an Analysis Services (formerly OLAP) connection

If the current SQL database does not answer all of the questions that a user may ask, modify the SQL Project by adding a Microsoft® SQL Server™ 2000 Analysis Services data connection. Questions that require Multidimensional Expressions (MDX) can then be answered.

Note  There can be, at most, one SQL and one Analysis Services database for each project.

To add or change an Analysis Services connection

1. Select the project to which the Analysis Services database is to be added.
   
   
2. On the Project menu, click <Project name> Properties.
   
   
3. On the Data Connection tab, select Enable OLAP if adding an Analysis Services database.

   Note  Both SQL and Analysis Services databases can be enabled.

4. Click Change.
   
   
5. In the Select an Analysis Server dialog box, enter the Analysis Services server, select the database, and then click OK.
   
   
6. Click OK.

   The Analysis Services connection appears in the Project Explorer and Data View windows.

See Also

Expanding an English Query Model

Data Connection Tab (Project Properties Dialog Box)

Enabling Analysis Services for an English Query Model

Project Properties Dialog Box

Select An Analysis Server Dialog Box