Reverse Engineering Microsoft SQL Server 2005 Cubes

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

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.

  1. Select Tools > Microsoft SQL Server 2005 Analysis Services > Reverse Engineer Cubes 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.