Project Wizards

Use one of the Project wizards, either the SQL Project Wizard or the OLAP Project Wizard, to automatically create a project and model. Depending on your choice, the wizard uses an SQL database or a Microsoft® SQL Server™ 2000 Analysis Services database to build the model. These Project wizards:

• Extract all or a subset of the database based on the tables or cubes selected in the New <Database Object> dialog box.
  
  
• Create and define the entities and relationships based on the database objects selected from the database.

Options

Create

Include or remove an entity in the model and display the relationships that will be automatically created based on the database structure.

To display or hide the relationships that are automatically created, click +.

Entity

Display a list of potential entities and the relationships for each entity based on the database objects chosen in the New <Database Object> dialog box.

Select or clear a relationship to include it or remove it from the model.

Database Object

Display the database object that was used to create the entity.

See Also

Icons and Cursors Used in English Query

New <Database Object> Dialog Box

OLAP Project Wizard

SQL Project Wizard