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
- Select the project to which the Analysis Services database is to be added.
- On the Project menu, click <Project name> Properties.
- On the Data Connection tab, select Enable OLAP if adding an Analysis Services database.
Note Both SQL and Analysis Services databases can be enabled.
- Click Change.
- In the Select an Analysis Server dialog box, enter the Analysis Services server, select the database, and then click OK.
- Click OK.
The Analysis Services connection appears in the Project Explorer and Data View windows.