Generating Cubes for Microsoft SQL Server 2005

The Microsoft SQL Server 2005 Analysis Services add-in enables the generation of cubes.

1. Select Tools > Microsoft SQL Server 2005 Analysis Services > Generate Cubes to open the wizard.
   
   
   

   Click Next to continue.

2. Enter a server name, and select the database you want to generate to:
   
   
   

   Click Next to continue.

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

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