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
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