Enabling SQL for an English Query Model
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
To enable SQL by adding tables from another data source
To enable SQL by creating a new project with SQL Project wizard
To enable SQL by setting global properties
To enable SQL by setting data source properties