Show TOC

Reverse Engineering Microsoft SQL Server 2005 CubesLocate this document in the navigation structure

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

Context

Before reverse-engineering cubes, you should create one or more PDMs to model the tables which provide its data. As part of the reverse-engineering process, PowerDesigner will create links from the reversed cubes to these tables.

Procedure

  1. Select Start of the navigation path Tools Next navigation step Microsoft SQL Server 2005 Analysis Services Next navigation step Reverse Engineer 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 reverse from:


    Click Next to continue.

  3. The Select Cubes page lists the available cubes. Select the cubes you want to reverse engineer and then click Next to continue:


  4. The Configure Data Sources page lists the data sources that are required to populate the selected cubes. For each source, select the Physical Data Model in which the tables are modeled, and then click Next to continue:


  5. The Reverse Engineer Cubes page lists the cubes to be reversed:


    Click Finish to begin reverse-engineering. Progress is displayed in the wizard, which will close automatically after successful completion.