Chapter 14 DBMS-Specific Features

Reverse Engineering cubes

The Microsoft Analysis Services add-in lets you reverse engineer cubes.

To reverse engineer cubes:

1. Select Tools→Microsoft Analysis Services→Reverse Engineer 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 Source Model Selection dialog box appears to let you select the models linked to the selected data source.
4. Select source models and click OK.
   
   
   The Cube Selection dialog box appears. The state column indicates if the cube already exists in the current model. Cubes already existing are deselected by default.
5. Select the cubes you want to generate.
   
6. Click OK.
   
   Selected cubes are created or updated in the current model. If a dimension or a cube already exists, it is updated.

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