Chapter 12 DBMS-Specific Features

Microsoft SQL Server 2005 Analysis Services

PowerDesigner allows you to retrieve multiple dimension objects in a PDM in order to build cubes, and to create a new multiple-dimension diagram. From this diagram, you can generate cubes to a Microsoft SQL Server 2005 Analysis Server (SSAS).

Note   SQL Server 2005 Management Tools required
In order to use the analysis services add-in to generate and reverse-engineer cubes, you must have installed the SQL Server 2005 Management Tools client component.

Steps To enable PowerDesigner support for Analysis Services:

  1. Select Tools→General Options, and select the Add-ins category in the left-hand pane.
  2. Select the Microsoft SQL Server 2005 Analysis Services add-in (PowerDesigner.AddIn.Pdm.SQLServer.dll) and then click OK to install it and return to the model.

For more information, see "Managing add-ins" in the Models chapter of the Core Features Guide .

 

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