Chapter 15 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 to open the connection dialog box.
   
2. Enter a name for the server and database, and then click OK to open the Source Model Selection dialog box, which lists the models linked to the selected data source.
   
3. Select the appropriate source models and then click OK to open the Cube Selection dialog box, which lists all the available cubes The state column indicates if the cube already exists in the current model. Cubes already existing are deselected by default.
   
4. Select the cubes you want to reverse engineer, and then 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) 2006. Sybase Inc. All rights reserved.