Generating Cubes

The Microsoft Analysis Services add-in lets you generate cubes.

1. Select Tools > Microsoft Analysis Services > Generate Cubes to open the connection dialog box.
   
   
   
2. Enter a name for the server and database, and then click OK to open the Cube Selection dialog box, which lists all the available cubes. The state column indicates if the cube has already been generated. Cubes already generated are deselected by default.
   
   
   
3. Select the cubes you want to generate, and then click OK.

   The selected cubes are generated. If a cube already exists in the database, it is dropped before being recreated. If a dimension already exists, the selected cube reuses it. To be fully generated, a cube must have a complete mapping to a table before being generated.