Export (0) Print
Expand All

Enabling SQL for an English Query Model

SQL Server 2000

Enable SQL for an English Query model by:

  • Creating a new project with the SQL Project Wizard.

    Use the New Project command on the File menu to access the SQL Project Wizard. When using the SQL Project Wizard, the project is enabled for SQL only. Initially, when selecting the OLE DB provider, you must select the data source or server, and then enter the logon information. After logging on, select a database, and then specify the entities and relationships from the tables that you want in the project. The project is automatically created.

  • Importing tables from a SQL database to a previously created Microsoft® SQL Server™ 2000 Analysis Services (OLAP)–only project.

    Use the Import Tables command on the Model menu to add tables from a SQL database to the project.

  • Adding a SQL database to the English Query model by using the Enable SQL option on the Data Connection tab in the Project Properties dialog box.

    Important  You cannot access the underlying database structure of an OLAP cube in an English Query model unless you are a member of the OLAP Administrators group and the Microsoft Windows NT® 4.0 or Windows® 2000 user group on the server with the Analysis Services database for which you are building the model. You must have OLAP Administrator permissions to load the tables underlying the cubes using Decision Support Objects (DSO).

To enable SQL by adding a database

Model Editor

To enable SQL by adding tables from another data source

Model Editor

To enable SQL by creating a new project with SQL Project wizard

SQL Project Wizard

To enable SQL by setting global properties

Model Editor

To enable SQL by setting data source properties

Model Editor

See Also

Creating a Mixed English Query Model

Creating an English Query Model

Defining Entities in an English Query Model

Enabling Analysis Services for an English Query Model

Enabling Full-Text Search for an English Query Model

Expanding an English Query Model

Testing an English Query Model

Show:
© 2014 Microsoft