Enabling Analysis Services for an English Query Model

Enable Microsoft® SQL Server™ 2000 Analysis Services for an English Query model by:

• Creating a new project with the OLAP Project Wizard using an Analysis Services database.

  Use the New Project command on the File menu to select the OLAP Project Wizard. If OLAP Project Wizard is selected instead of the SQL Project Wizard, the project is enabled for Analysis Services. The project is created automatically after you select the Analysis Services server, the database, and the OLAP cubes to use. Then, specify the entities and relationships you want included from the OLAP cubes.

• Importing cubes to an English Query model.

  Use the select Import Cubes command on the Model menu to add an OLAP cube to your project.

• Adding an Analysis Services data source to the English Query model.

  Use the Enable OLAP option on the Data Connection tab in the Project Properties dialog box to add OLAP cubes and other objects to the English Query model.

To enable Analysis Services

OLAP Connection

Model Editor

Global Properties

Enable OLAP

Manually Map OLAP Objects

See Also

Creating a Mixed English Query Model

Creating an English Query Model

Defining Entities in an English Query Model

Enabling SQL for an English Query Model

Enabling Full-Text Search for an English Query Model

Expanding an English Query Model

Testing an English Query Model