Show TOC

Generating Cubes for Microsoft SQL Server 2005Locate this document in the navigation structure

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

Procedure

  1. Select Start of the navigation path Tools Next navigation step Microsoft SQL Server 2005 Analysis Services Next navigation step Generate Cubes End of the navigation path 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.