How to enable Analysis Services (formerly OLAP)

If there are questions that cannot be answered using only the SQL database or if it is desirable to speed retrieval of data for questions that are not about aggregation of data, create a mixed model by enabling Microsoft® SQL Server™ 2000 Analysis Services and importing the appropriate cube.

To enable Analysis Services

1. From the Project menu, choose <project name> Properties.

   If the <project name> Properties command does not appear on the Project menu, double click <project name>.eqm in the Project Explorer window.

2. On the Data Connection tab, select Enable OLAP.
   
   
3. Enter the path to the database or click Change and select the path.
   
   
4. The Type and Version should automatically appear. If not, select MSOLAP for Type and enter the version number.

See Also

Analysis Services in English Query

Data Connection Tab (Project Properties Dialog Box)

Project Properties Dialog Box