The Microsoft SQL Server 2005 Analysis Services add-in enables the generation of cubes.
Procedure
- Select to open the wizard.
Click Next to continue.
- Enter a server name, and select the database you want to generate to:
Click Next to continue.
- The Select Cubes page lists the cubes available in the model, along with whether they currently exist in the database. Select the cubes you want to generate:
Click Next to continue.
- The Generate Cubes page lists the cubes to be generated:
Click Finish to begin generation. Progress is displayed in the wizard, which will close automatically after successful completion.
If a cube already exists in the database, it is dropped and recreated. If a related dimension already exists, it is reused. To fully generate a cube, your model must include a complete mapping to a table.