How to create a project using the OLAP Project wizard
The OLAP Project Wizard helps to create an
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.