Chapter 14 DBMS-Specific Features

Generating cubes

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

To generate cubes:

1. Select Tools→Microsoft Analysis Services→Generate Cubes.
   
   The connection dialog box appears.
   
2. Type a server name. You can directly type the database name or open the dropdown listbox in order to select a database name retrieved from the server.
3. Click OK.
   
   The Cube Selection dialog box appears. The state column indicates if the cube has already been generated. Cubes already generated are deselected by default.
4. Select the cubes you want to generate.
   
5. Click OK.
   
   All cubes selected in the cube selection dialog box 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.

Copyright (C) 2005. Sybase Inc. All rights reserved.