How to create a project using the OLAP Project wizard

The OLAP Project Wizard helps to create an English Query application from an Microsoft® SQL Server™ 2000 Analysis Services database. Use the OLAP Project Wizard to create either an Analysis Services project, including extracting the structure of a database and creating and defining the entities and relationships for an English Query application.

To create a project using the OLAP Project Wizard

On the File menu, click New Project.
In the Name box of the New Project dialog box, enter a name and select a location for the project.
Double-click OLAP Project Wizard.
Connect to the database using the Select An Analysis Server dialog box, enter the name of the server and select the database to use.
In the New OLAP Cubes dialog box, select the OLAP cube or cubes to be made accessible to the model.
Either double-click the available cube or cubes or select the cube and click the > button.

Note To include all of the cubes, click the >> button. To remove one or more cubes from the Selected list, select the ones to remove and click the < button. To remove all of the cubes from the Selected list, click the << button.
In the Project Wizard, select or clear the entities and relationships to be included or removed from the project.
Expand the entities to view the relationships that can be automatically created from the Analysis Services database structure.
When the entities and relationships are selected, click OK.
You can further refine the model by adding entities and relationships as needed to answer more of the questions users are expected to ask.

How to create a project using the OLAP Project wizard

See Also